I'm not a C# expert either... 🙁

this gets me the error:

Syntax error, bad array declarator. To declare a managed array the rank specifier precedes the variable's identifier. To declare a...

Thanks Mark, this works really nice.

Mark (4/10/2008)

with cte as (

select GroupColumnA,

GroupColumnB,

GroupColumnC,

...

Yes. Pivot performs an aggregrate on one grouping column and makes a column for each row. Not quite what I need.

I...

If you take the statement provided in the QotD and run it to create the table, you will end up with no table and an error message. (the command in...

Hi Steve,

I just wrapped up an 8 year contract, where I was able to work from home and go in 1 day a week.

While normally I have an  introverted personality, I...

Steve - doesn't Billy Joel, Greatest Hits vol 1 & 2 count as 2? Bringing your total to 6.

I'd rip all by CD's to MP3, and burn all of those...

I'm a military brat, born overseas, but grew up in Virginia Beach. I now live about 140 miles from VB (but work about 90 miles from there).

Hey Steve, what part...