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.

Sting manipulation? Complex mathematical calcs? Heh... Let's have a race... let's start with string manipulation... How about splitting a comma seperated column and returning a table with the...

Then I'd use a function with a table variable... not gonna hurt performance any more than a stored proc.

How many rows do you intend to return with 250 columns?