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

Heh... a Yak by any other name...

Sure... look at the problems you're having now with trying to keep the data unique.  Which do you think will be more effecient... doing a two line insert (INSERT/SELECT UNION...

Tk,

At the risk of ticking off "Mr Rogers", just some additional information... I believe that "performance tuning" effectiveness ratios are as follows:

1% - Hardware

2% - Server configuration

2% - Proper Indexing

95%...

Finer resolution on locks will sometimes decrease performance... nothing faster than a full table lock because it is only one lock.  Of course, you might not want to do that...