I want sql Query for below table

Question

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