I store the output in two tables and do a Full Outer Join on their key columns to compare.

Much better... if you have a joined update, the object of the join MUST be in the FROM clause or you could end up pinning 4 cpu's to the wall...

Ya beat me...

Simon,

You're kinda new to the forum... take a look at the link in my signature below to get better, tested answers quicker...

For more infomation on the method used above, please see the following link...

[font="Arial Black"]Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

[/font][/url]

This is how you do ROW_NUMBER() OVER in SQL Server 2000 with any performance at all. It's almost as fast as ROW_NUMBER () OVER...

Using the test data previously provided...

--=====...

I'm probably the world's biggest fan of the Tally table... keep that in mind when I say that Tally table solutions are probably not appropriate nor as fast as a...

You might find that SELECT TOP (xxxx) works pretty well as a sub for the Limit statement, as well.

The PIVOT method is slower than a good ol' fashioned cross-tab... see the following article, please.

[font="Arial Black"]Cross Tabs and Pivots, Part 1 – Converting Rows to Columns[/font][/url]

Also, dunno if you...

Basically, you're trying to pass a "table" or "array" of data in that it has rows and columns. Please see the following article...

[font="Arial Black"]

Passing Parameters...

The correct syntax is WITH (TABLOCKX)... parenthesis included.

Also, Seth pointed out some basic faults with you code like missing an anchor column... go back a take a look at his...

Ummm... wouldn't an index view work just fine here?

You noticed that the self taught guy did the best out of your employees...

... continue the trend and continue to teach yourself... start answering questions on this forum... compare with...

Valid for all AFTER triggers on the same table regardless of how many there are... I don't have the test code to prove it, anymore, but someone could do...

jcrawf02 (12/1/2008)

Charles Kincaid (12/1/2008)

Jeff Moden (11/29/2008)

Some folks store unknown or "open" dates as 99991231 so they don't have to check for null to see if an enddate has occurred in...