Viewing 15 posts - 3,571 through 3,585 (of 5,590 total)
Andrew Fowler-367854 (8/26/2010)
I currently have a Windows2003 cluster running SQL2005. We are about to do a harware refresh and want to upgrade to SQL2008R2 to take advantage of some new...
August 26, 2010 at 7:51 pm
CirquedeSQLeil (8/26/2010)
WayneS (8/26/2010)
CirquedeSQLeil (8/26/2010)
Alvin Ramard (8/26/2010)
CirquedeSQLeil (8/26/2010)
Well, we can see that Wayne has come into some more free time 😉I wonder which DBCC TimeWarp parameter value(s) he's using.
716 (caffeine)
1892 (morphine)
346...
August 26, 2010 at 7:32 pm
CirquedeSQLeil (8/26/2010)
Alvin Ramard (8/26/2010)
CirquedeSQLeil (8/26/2010)
Well, we can see that Wayne has come into some more free time 😉I wonder which DBCC TimeWarp parameter value(s) he's using.
716 (caffeine)
1892 (morphine)
346 (HGH)
I guess...
August 26, 2010 at 6:06 pm
Jeff Moden (8/26/2010)
drew.allen (8/25/2010)
August 26, 2010 at 5:52 pm
Jeff Moden (8/26/2010)
jvanderberg (8/26/2010)
Didn't you ask if it could be done in one SELECT statement?
Who? The OP? I don't see that anywhere in the original or subsequent posts...
August 26, 2010 at 5:50 pm
sqlbi - You might want to take a look at this post - this poster did everything right for how to get helpful answers. And the answer is right in...
August 26, 2010 at 5:48 pm
GilaMonster (8/26/2010)
The deadline has been set for about 3 weeks.
The requirements were finished...
August 26, 2010 at 5:41 pm
Alvin Ramard (8/26/2010)
I think I'm going to need new padding on my walls. :w00t:http://www.sqlservercentral.com/Forums/Topic975982-1550-1.aspx
Oh jeez.....
August 26, 2010 at 5:39 pm
Lutz, you done it again! I've learned two things from your post:
1. I thought that you had to reference the nodes as a.c.value, etc. in the column list area of...
August 26, 2010 at 2:46 pm
LutzM (8/26/2010)
CirquedeSQLeil (8/26/2010)
Should I stay or should I go now?
If you go there will be trouble. An’ if you stay it will be double.
So, in order to minimize trouble: RUN,...
August 26, 2010 at 2:03 pm
sqlbi (8/26/2010)
The Link you provided is good, im trying it using pivot function in SQL 2008. can you help me with that?
That article does an excellent job of walking you...
August 26, 2010 at 1:54 pm
Great explanation Lowell!
jnichols - what is the intent if a null is passed in for one of the parameters? To get all values, or to get values where that field...
August 26, 2010 at 1:51 pm
Just make sure that the variable is in scope for the script task. When you start the script task, the code shows you how to reference variables. You will need...
August 26, 2010 at 1:37 pm
1. In your stored procedure, use the output clause of your insert statement to put all inserted records into a temp table or table variable. Then insert the appropriate column...
August 26, 2010 at 1:23 pm
I don't see anything that would cause that kind of delay. Is this the entire procedure?
Do you have an index on greg_date?
But:
Set @Year = (select YR_NUMBER from sword_calendar where @Today...
August 26, 2010 at 1:18 pm
Viewing 15 posts - 3,571 through 3,585 (of 5,590 total)