Parthiban B

Parthiban B

  • NA
  • 50
  • 18.5k

Sql Query for my below tbl

Aug 19 2013 12:30 AM
Table name ->datatbl

Columns  ->line,workorderno,bundleno,style,code,scandate,scantime

Actual   sqlserver TBL like this   

Line Workorderno Bundleno Style code scandate ScanTime
l1 123 1210 AC234 2 03-08-2013 10.11
l1 123 1210 AC234 1 03-08-2013 11.15
l1 123 1210 AC234 4 03-08-2013 13.17
l1 123 1210 AC234 3 03-08-2013 15.32
l1 123 1210 AC234 2 03-08-2013 10.14
l1 123 1210 AC234 1 05-08-2013 11.21
l1 123 1211 AS232 8 03-04-2013 14.52
l1 123 1211 AS232 7 04-04-2013 10.45

code -> odd Numbers are Send Scan code AND Even Numbers  Are Recv Scan Code
EXPECTED RESULT

Line Workorderno Bundleno Style code senddate SendTime RecvDate RecvTime
l1 123 1210 AC234 03-08-2013 10.11 03-08-2013 11.15
l1 123 1210 AC234 03-08-2013 13.17 03-08-2013 15.32
l1 123 1210 AC234 03-08-2013 10.14 05-08-2013 11.21
l1 123 1211 AS232 03-04-2013 14.52 04-04-2013 10.45
in code column odd number or even number of particular value  column value  is enough to show for example if 2,1 means display 2 is  enough

Please Help Me
Thanks in ADVS

Answers (8)