You bet... Thanks for the feedback.

Just remember...if the count of rows for each group starts to grow, the performance will suffer greatly very...

Doh!... Thanks for the correction, Peter... that's what I get for late night posting. I'll correct that post...

Yes, I absolutely agree... any type of formatting should be done only in the GUI... if there is one...

But the keyword in the title of the thread is "Show"......

C'mon... I know you're in a pinch but stop and think about it... we don't know what your SalesDetails detail table looks like, we know nothing about the data in...

Oh... be careful, now... IsNumeric cannot be equated to IsAllDigits. IsNumeric will allow currency symbols, $, comma, decimal point, spaces, tabs, and a host of other individual characters. ...

This was a pretty interesting question with no responses and I have no idea of what the answer might be... anyone got any idea on this, at all?

... and when it comes to % of batch, it can still lie!

EDIT:

I originally (incorrectly :blush: ) suggested do something like this... but, as Peso pointed out below, it's going to throw an error if table doesn't actually exist. My appologies...

OP has "left the building"... 😛

Heh... dang... thanks Kevin! I should'a looked in BOL...

Matt Miller (2/15/2008)

---

...It's a shame it took them all of the way until 2005 to hear the clamouring out there, so that they introduced the "include column headers into the...

Thanks for...

Matt Miller (2/15/2008)

---

I suppose you're going to tell me I'm getting to be predictable now.... :hehe:

There's the obvious way, emulating a SQL-style cursor, which seems oh so very obvious. ...

Frank,

Heh... understood on things possibly changing...

It's a bit funny... for years, people jumped on me for using the occasional undocumented feature (xp_DirTree to be specific) because "Microsoft could...

TheSQLGuru (2/15/2008)

---

2) use of a table variable voids the use of parallelism which can significantly reduce performance for large dataset processing./quote]

Kevin, do you, by any chance, have a Microsoft article...