>>I know of 3 ways to make the desired output. I am not giving them up, though. One version works in any versions of SQL Server and also in FoxPro as well.
>
>I just read a third way - might be the same as yours or might be something different (in which case we have four!)
>
>Let's see what our friend from the Netherlands has. (And hey, maybe even the founder of the Captain Cooker society will weigh in) :)

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1df56092-8929-4c6c-89dd-e928db9a6af0/unpivot-pivot-without-aggregation?forum=transactsql