TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Parthiban B
NA
50
18.4k
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
Reply
Answers (
10
)
How to do table partioning in sql server 2008 r2
I have a problem in creation of table with CONSTRAINT in sql