SELECT [Case Number], [Author 1], [Author 2], [Author 3] FROM ( SELECT [Case Number], [Author 1], [Author 2], [Author 3] FROM [Gold Metadata] ) UNPIVOT (Orders FOR [Gold Metadata] IN ( [Author 1], [Author 2], [Author 3]) )AS unpvt; GO
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)