Parthiban B

Parthiban B

  • NA
  • 50
  • 18.3k

I want sql Query for below table

Aug 9 2013 4:06 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 (10)