| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hello,
Does anybody know, MSSQL 2005 T SQL language, are variables or keywords case
sensitive or not?
Regards
m
|
Today 11:07 AM
Plamen Ratchev  | 3 | 4 |
| | | I have one machine with an application running that many users need to log
in and out of quickly. Logging off the machine, logging in and...
Matthew Wells
|
Today 10:20 AM
Matthew Wells | 0 | 1 |
| | | We are using SQL Server 2008.
As an administrator on the box (part of the admin group), I assumed I
could use Windows authentication to log into sql...
Justin
|
Yesterday 03:11 PM
alen teplitsky | 2 | 19 |
| | | I am trying to create a stored procedure to write out to a text file.
I would like it to write a line for each instance of a select
statement. Any...
mcolson
|
03-08-2010 06:03 PM
Erland Sommarskog | 2 | 10 |
| | | Hello
I have an ASP/SQL Server 2008 client management application. An ASP
textarea submits data to a varchar(max) field. In some cases the...
ContainsCaffeine
|
03-08-2010 04:23 PM
ContainsCaffeine | 2 | 10 |
| | | I am not clear why SQL Server eliminates dups from my query below
declare @s table ( id int );
insert into @s (id)
select 1 union
select...
migurus
|
03-03-2010 10:48 PM
Plamen Ratchev | 1 | 16 |
| | | The Yellowfin BI team have produced a new paper on "Location
Intelligence", the mashup of BI with GIS
Extract
More than 70% of your organizational...
JTP PR
|
03-03-2010 05:04 AM
JTP PR | 0 | 15 |
| | | Hi:
Please, Iīm looking for a SQL query to get data of last 3 months.
(We are in March, 2 so I need a query to show me data from Dec/01/2009
until...
valdemirs
|
03-02-2010 06:54 PM
Plamen Ratchev | 1 | 17 |
| | | Consider a table and a query referring to only a subset of the columns
in that table. How early in the query evaluation is the projection
carried...
jbdhl
|
03-02-2010 04:23 PM
Gert-Jan Strik | 5 | 17 |
| | | We at Nob Hill Software are working on a new query tool:
http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut
You can read all about it on the...
Mia
|
03-01-2010 08:50 AM
Mia | 0 | 14 |
| | | Hi:
Please, could you help me with this SQL query ?
I need get data from last 3 months,
but itīs shows me only January's data.
(Query doesnīt get...
valdemirs
|
02-27-2010 01:21 PM
Erland Sommarskog | 1 | 31 |
| | | On Tue, 23 Feb 2010 23:02:32 -0800, seven <s_e_v_e_n (AT) gawab (DOT) com> wrote:
The way I solve this is by first finding the max rows:
select...
Tom van Stiphout
|
02-27-2010 10:51 AM
seven | 3 | 21 |
| | | Hi all
I have this query
SELECT COUNT(*)
FROM Pro
WHERE D_TIME BETWEEN '2010-02-14 00:00:00.000' AND '2010-02-20
23:59:59.000'
AND...
hayko98
|
02-26-2010 06:19 PM
hayko98 | 2 | 28 |
| | | Suppose you were looking at widget manufacturing data, and your DB
looked like...
dvestal@gmail.com
|
02-26-2010 05:44 PM
Gert-Jan Strik | 1 | 14 |
| | | Hi.
I don't really have a problem per se but since I am not a 24/7 DB
developer I'd appreciate an experienced set of eyes to provide some
feedback...
pbd22
|
02-23-2010 07:25 PM
pbd22 | 1 | 25 |
| | | I've been tasked with designing an application to capture data about
sports clubs.
Let's say there are four different types of club - Soccer,...
Edward
|
02-23-2010 09:33 AM
TheSQLGuru | 6 | 27 |
| | | Hi,
I am trying to design a db schema (or rather extend existing db
schema). My goal is to extend the database table so that every time a
new column...
Raju_QC
|
02-23-2010 03:06 AM
Nilone | 4 | 37 |
| | | Is there anyone out there who can tell me how to place a simple
message from within T-SQL into my Outbox of Outlook (not Outlook
Express) on the same...
ab
|
02-23-2010 02:54 AM
ab | 0 | 10 |
| | | SQL Server 2005 SP2 9.0.3054
I would like to move my DB (with Full Recovery Model) onto a
/different/ server. I would like to do this w/o losing...
aj
|
02-19-2010 12:47 PM
Erland Sommarskog | 1 | 37 |
| | | Hello,
does the SQL Server 2005 or 2008 have an API for the programming language C?
Regards, Domenic
Domenic Laritz
|
02-18-2010 02:34 AM
Erland Sommarskog | 1 | 21 |
| | | Hello
I wonder whether you may have some hints and pointers. I'm trying to
create an ODBC User/System DSN but can't see the SQL server in the
ODBC...
theintrepidfox
|
02-18-2010 02:33 AM
Erland Sommarskog | 3 | 30 |
| | | SQL Server 2005 SP2 9.0.3054
Using the
EXEC sp_dropserver '<old>'
GO
and
EXEC sp_addserver '<new>', 'local'
GO
commands, I have successfully changed...
aj
|
02-17-2010 03:34 PM
aj | 0 | 11 |
| | | Hi all,
I am trying to configure SQL Server 2008 for Office 2007 Data Mining
Add-ins. And on the connection set up screen, it asks for the...
SQL Learner
|
02-16-2010 05:21 PM
SQL Learner | 0 | 23 |
| | | I made a web. For those people who want learn and earn by
internet .please visit the...
John Smith
|
02-13-2010 05:07 AM
John Smith | 0 | 32 |
| | | I'm running a website with NetworkService credentials and I'm able to
connect fine on one DB, but not the other. Both DBs are running SS
2008, and...
Dave
|
02-12-2010 05:46 PM
Erland Sommarskog | 1 | 21 |
| | | Hi,
I am trying to port a set of Python programs originally working with
PostgreSQL, to use SQL Server 2008 with Windows XP... and it is harder
than...
Pascale Mourier
|
02-10-2010 05:49 PM
Erland Sommarskog | 1 | 39 |
| | | I have this wierd problem. I have created a number of login on SQL
2008 on WindowsXP without any problem. Now I start do it on Window 7,
and I keep...
daicamad
|
02-09-2010 03:21 PM
daicamad | 1 | 21 |
| | | Hi All,
If I have the following one-column table:
Grade
80
100
90
60
50
SQL Learner
|
02-09-2010 12:11 PM
Gert-Jan Strik | 7 | 42 |
| | | Hi all,
Three related questions.
Q1)
I tried the following code and it works with
set @c = CHAR(@x + ASCII('a')) + '-' + @c
but it does not work...
SQL Learner
|
02-08-2010 10:31 PM
SQL Learner | 2 | 23 |
| | | Somewhat noobish here with SQL. Have done some packages with DTS and
MSDE. Looking for some guidance on the following project:
Need to develop a...
dorkygrin
|
02-08-2010 05:32 PM
Erland Sommarskog | 1 | 15 |
| | | Hi all, while I work on SQL Server for some time but never being on
admin tasks.
I install SQL Server 2008 on Admin account of Windows 7, create...
daicamad
|
02-08-2010 05:21 PM
Erland Sommarskog | 1 | 13 |
| | | Hi All,
Here is a more challenging question derived from my last one in...
SQL Learner
|
02-07-2010 08:07 PM
SQL Learner | 4 | 16 |
| | | Hi All,
Hope someone can help to solve this SQL question.
I have the following table called '#temptable' (it is a temp table)
source price ...
SQL Learner
|
02-07-2010 07:45 PM
SQL Learner | 8 | 14 |
| | | Yellowfin Business Intelligence an entirely new dimension in Location
Intelligence has provide Jet Interactive with a significant
competitive...
JTP PR
|
02-07-2010 12:25 AM
JTP PR | 0 | 29 |
| | | I've installed SQL Server 2005 on a dozen machines before but now I'm
stumped trying to install on Windows 7. I have installed the app,...
Lauren Quantrell
|
02-06-2010 02:45 PM
Tom van Stiphout | 1 | 30 |
| | | Our organization made a preliminary decision to store data for all new
projects in a single database because there is some commonality...
Mike Husler
|
02-03-2010 05:52 PM
Erland Sommarskog | 1 | 37 |
| | | Hi...I need to return the Top 20 customers by 'Accounts Receivable
Balance' (= FutureBal + Per1Bal + ... + Per5Bal + Misc_Creds +
Unapplied) in the...
LightBulb
|
02-03-2010 04:35 PM
Plamen Ratchev | 1 | 23 |
| | | I am running an SSIS job manually that I am trying to automate.
To automate the task the job needs to run daily and execute when a
condition is...
robboll@hotmail.com
|
02-02-2010 10:26 PM
robboll@hotmail.com | 1 | 29 |
| | | So, I have a series of tables with different columns (but some
'common')
e.g.
Sales order items (oritem)
Process order stock requirements...
Iain Sharp
|
02-01-2010 05:49 AM
Philipp Post | 6 | 51 |
| | | I much prefer examples and apologize that this question doesn't
have one.
I unfortunately can't post CREATE TABLE statements
for this problem...
bill
|
01-30-2010 09:16 PM
bill | 3 | 32 |
| | | SQL Server 2005 SP2 9.0.3054
I would like to copy/restore my DB (with Full Recovery Model) onto a
/different/ server. I would like to do this w/o...
aj
|
01-29-2010 12:56 PM
aj | 2 | 44 |
| | | Hi;
I'm trying to find the number of records in a table where field_1 is
not a substring in field_2.
My problem with the query below is that...
steve
|
01-28-2010 04:11 AM
Iain Sharp | 4 | 47 |
| | | Hi All,
I am trying to configure SQL Server 2008 for Office 2007 Data Mining
Add-Ins, but got stuck on the very first step - Connect to an...
SQL Learner
|
01-27-2010 05:10 PM
SQL Learner | 0 | 17 |
| | | I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer...
Virgina Hernandez
|
01-27-2010 02:36 PM
Virgina Hernandez | 0 | 26 |
| | | Does anyone happen to have sample code for code for "sql server
development with access 2000" by Wrox?
I am trying to get the sample code on their...
SQL Learner
|
01-26-2010 09:23 AM
SQL Learner | 0 | 27 |
| | | Hello,
I've created a simple SSIS package to migrate data from an Access 2003
mdb to SQL Server 2005. I made the package on my laptop (Windows...
Matthew Wells
|
01-25-2010 01:12 PM
Matthew Wells | 0 | 23 |
| | | Hi friends I m using SQL 2005 I want to concatenate multiple rows into
single row with comma separated. I tried using for XML and all but
what I m...
chintu4uin@gmail.com
|
01-25-2010 07:45 AM
Hugo Kornelis | 1 | 36 |
| | | Hello there,
I have a database with positional information in it along the lines of
waypoints of various journeys ('tracks'). I am currenetly using...
James Riches
|
01-24-2010 06:01 PM
Erland Sommarskog | 1 | 29 |
| | | Hi.
I am using the following SQLHelper code:
http://www.sharpdeveloper.net/source/SqlHelper-Source-Code-cs.html
I am trying to use a Sql Function...
pbd22
|
01-22-2010 05:35 PM
Erland Sommarskog | 1 | 34 |
| | | I have been working on implementing DDL Triggers, to monitor changes
in our environment. However, it doesn't seem to behave with
Replication - at...
M Bourgon
|
01-22-2010 12:05 PM
M Bourgon | 0 | 30 |
