question

SHAHGEE avatar image
SHAHGEE asked

SQL Help

i have one table including four columns. ( Job#, Operation_code, Item, Qty). one job may have different operations. for exp, job 1 have 5 operations, job 2 have 7 operations, job 3 have 3 operations,and Qty is moving from one operation to other untill it reach to the last operation. in my out put i want to show if the qty reach to the last operation, it shows last operation in extra column. can u please help.
sql server
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
What have you tried so far?
2 Likes 2 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
If you can post some schema creation scripts, some scripts to populate that with sample data, and the required output in a suitable table, and then show us what you've tried and what you're having problems with, then maybe we'll be able to help. See this post for more information on how to post a T-SQL-related query to a forum: https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
1 Like 1 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.