20 Sep 2011 by sachin10d
Try thisselect empCode, [Date], [1] intime ,[2] break_out,[3] break_in,[4] outtimefrom(select empcode,convert(date,[DATE]) [date],convert(time,[time]) time ,ROW_NUMBER() over(partition by empcode,date order by empcode,date,time) Tin from emp)datapivot( max([time]) for Tin...