SELECT Agent, Date, Shift FROM (SELECT Agent,[01/06/11],[02/06/11],[03/06/11],[04/06/11]) from shiftTable UNPIVOT (Shift FOR Date IN ([01/06/11],[02/06/11],[03/06/11],[04/06/11]) )as unpvt;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)