I did some further analysis on Jeff Moden's example and I'm convinced his cross tab method is the proper way to go, I just converted a query that is almost...

Jeff Moden (12/13/2015)

---

pcanino70 (12/13/2015)

---

Well done! Like the results. The one thing I like about the pivot is for me it allows easy expansion if you need to fatten this out...

Jeff Moden (12/11/2015)

---

Ok... I realize that this is an older thread but people are still posting PIVOTs to do this and that's going to be slower than a good CROSSTAB....

x

You could add a category column and pivot

with cte

as

(

select LotNo

, ( row_number() over ( order by LotNo ) + 2 ) % 3 as Remainder

...

In the past I've found that SQL Cursor are slow and difficult to use. An alternative is to use a while loop with a table variable that stores a...