Duplicate records DO happen on staging tables used for preprocessing rows from third parties, especially telephone companies... Either a "UNIQUE WITH IGNORE DUPES" index must be used (comparitively very slow)...

Heh... you're right... wrong article... it was about "RAAS", not "RAC"...

You'r still nothing more than a spammer...  I can't understand why you don't get your product evaluated on this site......

This should do it nicely... classic cross-tab... you might be able to use SQL Server 2005 PIVOT as well... either way, it'll solve your slowdown because each row is only...

Now... that's a bummer...

Spot on, Vladan

Also, be aware that this method uses a "Triangular Join" which can get very slow if the "triangles" are allowed to get to any size... they can be hundreds of times...

So, why not post how to make a "Numbers" table or provide the actual link?  Aren't we a full service shop?

Venkat... here's how...

Karthik,

I get it from your description... Can't work on it right now because I'm on the way to work, but I've got to ask...

Why doesn't "he" want these flattened out...

The article was nice and simple... shows how to make and exec a proc that uses a table parameter.

What I'd like to know (and anyone can certainly answer) is why...

Heh... more spam... at least the table example works, Rog... Saw the free code you guys posted for RAC and apparently a lot of the stuff doesn't work correctly...

On a busy system, if it's a batch proc, wait 5 minutes after it's done, and it won't be cached any more.

On a busy system, if it's a GUI proc,...

Somebody,

If I have a lot of candidates with good resumes all lined up, I'll ask some questions outside of what the job specifically requires as "tie-breakers".

For example... let's say I...

Have you tried sp_HelpLogins?

Subtracting 2 milliseconds from the date won't do it because dates have a 3.3 millisecond resolution. 

And, instead of fooling around with the time for end date, why don't you...

There is no time such as 24:00:00.000 because that would represent the next day