Lowell (12/29/2009)

---

Justin James (12/29/2009)

---

Thank you for the help Lowell. I'll make sure to include the appropriate SQL in my further posts.

One question I have about your SQL:

select ID/6 as REC,...

Thank you for the help Lowell. I'll make sure to include the appropriate SQL in my further posts.

One question I have about your SQL:

select ID/6 as REC, [ID]% 6 as...

There is not. I was thinking of using ROW_NUMBER(), but was unsure how to partition by each block of 6 rows.

Yes, that is correct. Each block of 6 is destined to become a singular row in the final table.

Please see my original post for code to copy/paste.

I also setup a "dummy" aggregate to see if I could get that to work -- I used min(text) for columnname. However,...

That was the trick! Thanks Adi!

I have tried to put the semi-colon before the with Publishers, but I get an error which states "Incorrect Syntax near ';'

This is occurring because of the way that numeric values are sorted. The query processor goes by the first character that it sees, and sorts that way. That's why you...

That worked great -- just what I needed!

Thanks!

Michael Valentine Jones (3/16/2009)

---

I can't see why you would drop the clustered index and then recreate it, since that forces SQL Server to rebuild the table as a heap and...