Viewing 15 posts - 181 through 195 (of 205 total)
I need create a crosstab store procedure using pivot statement but SQL 2000 do not support pivot.
March 16, 2011 at 7:05 am
Derrick Smith, can you tell me more detail of how to do it?
March 7, 2011 at 8:09 am
So simple, I should find it out.
Thank you!
March 4, 2011 at 7:17 am
Thank you for help.
I used the way GilaMonster taught me and set identity on successfully.
March 1, 2011 at 6:43 am
But table x is already existing. If there is no data it is easier to set identity on in design view. Since there are about 100000 records in it, set...
February 28, 2011 at 4:59 pm
You are right.
After adding "go", it works fine.
What is happend?
Does SQL have refresh table command?
February 11, 2011 at 1:33 pm
SSCommitted, thank you so much. It works great!!!
February 10, 2011 at 12:53 pm
Thank all of you.
I try to run code from SSCommitted but I got an error as below. How to fix it?
Our company is still using SQL 2000. I do not...
February 9, 2011 at 12:30 pm
I am using SQL Server Management Studio 2008 Express
December 29, 2010 at 11:39 am
Sorry, I made mistake.
I attached new XLS file in which there are 12 columns including [ORDERID] and [SUM].
What I need is to update [Sum] column. [ORDERID] is primary key.
For example,...
December 15, 2010 at 12:59 pm
I tested it but became 'Jan 1 1900 12:00AM'
December 14, 2010 at 12:52 pm
Once create a table variable, I need to insert huge data into it. I want to create index after inserting.
December 6, 2010 at 2:58 pm
Viewing 15 posts - 181 through 195 (of 205 total)