Viewing 15 posts - 1,336 through 1,350 (of 3,221 total)
As Gail Show (GilaMonster ) has answered.
For example I have two (2) instances of SQL Server on a single machine
Instance Name . . . ...
March 28, 2011 at 6:55 pm
From BOL Boks On Line
The following is annotated syntax for PIVOT.
SELECT <non-pivoted column>,
[first pivoted column] AS <column name>,
[second pivoted column]...
March 28, 2011 at 3:26 pm
Without knowing exactly what you are doing, have you considered using your existing T-SQL to insert the results of each T-SQL statement into a temp table, And then doing...
March 28, 2011 at 3:01 pm
Hugo Kornelis (3/28/2011)
rmechaber (3/27/2011)
To me, it's goofy that 'yyyy-mm-dd' is not a universally acceptable and unambiguous date format (only 'yyyymmdd' is), but that seems to be the case.
It is goofy,...
March 28, 2011 at 5:54 am
Line added at 7:08 pm
Whoops took me too long to get my old system up and running.
bitbucket-25253 (3/26/2011)
On my SQL Server 2000...
March 26, 2011 at 5:07 pm
Running Craig Farrell code Posted Today @ 6:23 PM
On my SQL Server 2000
activity_code register_count line_count
------------- -------------- -----------
0987654321 ...
March 26, 2011 at 5:05 pm
hmbtx
Please post table definition(s), sample data for each table and required results from the sample data in an easy to use format. To accomplish this please click on...
March 26, 2011 at 3:34 pm
Your data as posted:
User ID Date
1 01\03\2011
1 02\03\2011
1 03\03\2011
1 07\03\2011
1 09\03\2011
1 010\03\2011
1 011\03\2011
Are these 2 entries in your actual data or simply a mistake in your entering here in...
March 26, 2011 at 2:39 pm
timotech (3/26/2011)
Thanks Jeff, i already solved the problem and only forgot to post it here. Thanks so much for your reply, it shows u care. I appreciate.
Hope you intend to...
March 26, 2011 at 2:31 pm
Try this for SQL 2000
SELECT 'Index Name' = i.name, OBJECT_NAME(i.id) AS 'Table Name',
Case Indid
WHEN 1 THEN 'Clustered'
ELSE...
March 25, 2011 at 5:23 pm
As much as I dislike doing what is given below, it is the only quick and dirty method I could come up with in SQL 2000.
1. Revised your table...
March 24, 2011 at 7:20 pm
I'm also not a fan of the Harry Potter books. The movie seemed like a study in ADD, nothing was really connected to anything else and the quidditch or whatever...
March 24, 2011 at 2:00 pm
ranganathanmca
Please note that this is code (not mine) posted by someone here on SSC whose name I forgot to record to give credit where credit is due....
March 24, 2011 at 8:26 am
Toreador (3/23/2011)
Asan Buhari (3/22/2011)
I wondered how SQL Server accepted an extra comma at the end of Create Table statement!No-one seems to have addressed this yet?
Undocument feature, or bug?
I tested the...
March 24, 2011 at 7:46 am
Viewing 15 posts - 1,336 through 1,350 (of 3,221 total)