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
Ravi Shekhar
361
4.5k
2.1m
problem at the time of fetching data in sql server
Aug 1 2013 6:37 AM
Now when i run this query
Select distinct slot_code,COUNT(MonoboxNo) capacit from wms_loose_transaction
Where Statustemp='PKL035311' and left(monoboxno,7)='1619199' and statustemp1='H' group by slot_code
I got SAFL21 20
but i need order wise like in above table i have two orders with same artno
not i need to fetch data order wise.
desired data SAFL21 10 for both orders.
Pls give me a query.(above image in attachment.you can download for reference)
Reply
Answers (
12
)
Sql server
cursor in sql server