October 31, 2017 at 11:58 pm
Hi
I have data like below . I want Group By Prod Group having Value = 5 . Under that Group i want to display all Item Nos till next Prod Group value = 5 and so on
In below Case
1000 Main Group , under that i want to display data of Items 1001 , 1002, 1003, 1004 till 1049.
1050 Main Group , under that Items 1051 , 1052 till 1099 to be displayed.
Item Code Prod Group
1000 5
1001 2
1002 2
1003 2
1004 2
1050 5
1051 2
1052 2
1100 5
and son on
Thanks
November 1, 2017 at 12:24 am
jagjitsingh - Tuesday, October 31, 2017 11:58 PMHi
I have data like below . I want Group By Prod Group having Value = 5 . Under that Group i want to display all Item Nos till next Prod Group value = 5 and so on
In below Case
1000 Main Group , under that i want to display data of Items 1001 , 1002, 1003, 1004 till 1049.
1050 Main Group , under that Items 1051 , 1052 till 1099 to be displayed.
Item Code Prod Group
1000 5
1001 2
1002 2
1003 2
1004 2
1050 5
1051 2
1052 2
1100 5
and son on
Thanks
Can you please post the DDL (create table) script, sample data as an insert statement and the expected results.
😎
This problem is trivial but most of us do not have time for creating example sets or guessing the meanings of wage ambiguous questions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply