SQL 2008 Script for converting vertical to horizontal

Z

zidrave

New Member
I am a new in SQL, Pleasae help me how can i convert it into horizontalExample:(Old)No Mchn EnNo Name DateTime 00001 1 01110037 Juan 2012/07/16 08:00:1800002 1 01110037 Juan 2012/07/16 12:02:2300003 1 01110037 Juan 2012/07/16 12:42:2300004 1 01110037 Juan 2012/07/16 18:42:2300005 1 01110038 Robert 2012/07/16 08:00:1800006 1 01110038 Robert 2012/07/16 12:02:2300007 1 01110038 Robert 2012/07/16 12:42:2300008 1 01110038 Robert 2012/07/16 18:42:23Result that i want to show..(New)EnNo Name Date TimeIn BrkIn BrkOut TimeOut01110037 Juan 2012/07/16 08:00:18 12:02:23 12:42:23 18:42:2301110038 Robert 2012/07/16 08:00:18 12:02:23 12:42:23 18:42:23
 
You must log in or register to reply here.
Back
Top