sql

Question

 
 


 
 
 
 
 
 
 
 


 
 
 
 
 
 
 
 


 
 
 
 
 
 
 
 


 


 


 
 
 
 
 
 
 
 


 
 
 
 
 
 
 
 

Values In Sql Table
	Wkno	Bundleno	Style	Code	Scanned Date	Scanned Time
in	123	12110	ABC	2	07-08-2013	10.00
out	123	12110	ABC	1	08-08-2013	13.00
Expected Result
Wkno	Bundleno	Style	Code	Scanned In Date	Scanned in Time	Scanned out Date	Scanned out Time
123	12110	ABC	2	07-08-2013	10.00	08-08-2013	13.00