Heh... my work is almost done here...

Peter, did you have some...

... and what happened to the Cross-Apply Peter was talking about?

Yes, I used the tally table (or as you named it (myNumbers).

I didn't realize you wanted the Clustered index removed for the test.

So the new results with the PK...

This is starting to be a little like pulling teeth, Phamm...

Why does the report need to be in this format? No fair saying the users want it that way......

Jason,

Did you test only the Tally table method? Sorry, I can't really tell from your post...

You're getting a "scan" on the Tally table? Did you remove the Clustered Index it had?

On which method, Peter?

Took the words right out of my mouth... prize for participants and casual observers alike will be more knowledge. "Some of the best 'Things' in life are not 'Things'"...

Cool... now we're talking some testing!

Seriously, Phamm...

I just wanna know before-hand for 2 reasons... will determine the method I use and I'm collecting "reasons" for this... just explain why you need to do this. ...

Did you find a link, Jonathon?

I won't pass a table variable... best you can do is a result set that get's used as a table.

Shaun McGuile (11/13/2007)

---

As neither is 'wrong', they both work then its a matter of personal choice/practice.

Just be consistent and be prepared to do translation when porting your SQL to other...

Heh... You know me, Shaun... I even challenge myself if I think I'm wrong 😀 Good man once told me "A Developer must not...

Sure... a little off topic... but I love it! Looking forwards to your post(s), Gail.