Viewing 15 posts - 1,981 through 1,995 (of 5,590 total)
Thanks for providing the table DDL and sample data.
Here's the quirky update method.
-- First, we need a different clustered index.
-- So, dump the data into a temp table with...
January 6, 2011 at 8:52 am
Jeff Moden (1/6/2011)
... Credits to Navy beans ...
Huh?
January 6, 2011 at 7:45 am
Brandie Tarvin (1/6/2011)
Jack Corbett (1/6/2011)
January 6, 2011 at 7:20 am
Steve Jones - SSC Editor (1/5/2011)
Just came back from a neighborhood meeting. Now I need to go shovel more manure around in my barn.
So, is the second part related to...
January 6, 2011 at 4:59 am
Brandie Tarvin (1/5/2011)
EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves are for beginners.
I...
January 6, 2011 at 4:57 am
cengland0 (1/6/2011)
There are several ranking functions:RANK
DENSE_RANK
NTILE
ROW_NUMBER
Yes, there are several. However, this question is about the RANK() function, so why even bring these others into the mix?
When the question asked...
January 6, 2011 at 4:50 am
Check out this article on SQL Server Ranking Functions[/url]. It looks like the ROW_NUMBER() function will do what you're after.
January 5, 2011 at 8:11 pm
The reason for those table locks is to avoid assigning the same number to two different processes at once. Since what I wrote is set-based, it's working outside of their...
January 5, 2011 at 3:40 pm
There are plenty here on this site; just search for dependency in the scripts section.
January 5, 2011 at 3:35 pm
CirquedeSQLeil (1/5/2011)
Brandie Tarvin (1/5/2011)
January 5, 2011 at 10:39 am
Brandie Tarvin (1/5/2011)
January 5, 2011 at 10:16 am
GSquared (1/4/2011)
January 5, 2011 at 8:31 am
I'm a bit curious - when would you have a condition where you want the task to report as successfully completed when it actually failed?
January 5, 2011 at 6:53 am
Viewing 15 posts - 1,981 through 1,995 (of 5,590 total)