Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
8
Reply
Sql Query for my below tbl
Parthiban B
Aug 19 2013 12:30 AM
1.5k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
procedure to insert and delete using sql server 2008
Procedure and Benefits of SQL Jobs