robert030975
MIS
- Oct 17, 2006
- 227
HI
I'm in need of some help grouping some data
partNo Qualification SequentialNumber SortOrder Sets
877 Vehicle Equipment 10801 00003 1
877 To construction year 10801 00004 1
877 Block Separation 10801 00005 1
877 To construction year 10801 00006 2
877 Vehicle Equipment 10801 00007 2
877 Vehicle Trim Level 10801 00008 1
877 Vehicle Equipment 10801 00009 3
877 Block Separation 10801 00010 2
877 To construction year 10801 00011 3
877 Vehicle Equipment 10801 00012 4
877 Vehicle Trim Level 10801 00013 2
This is after using
ROW_NUMBER() OVER(PARTITION BY Qualification, SequentialNumber, partNo ORDER BY SortOrder ASC)
What I need is to do is within the qualification can you partition by specifically Block Speration ?
so it would read as follows
partNo Qualification SequentialNumber SortOrder Sets
877 Vehicle Equipment 10801 00003 1
877 To construction year 10801 00004 1
877 Block Separation 10801 00005 1
877 To construction year 10801 00006 2
877 Vehicle Equipment 10801 00007 2
877 Vehicle Trim Level 10801 00008 2
877 Vehicle Equipment 10801 00009 2
877 Block Separation 10801 00010 2
877 To construction year 10801 00011 3
877 Vehicle Equipment 10801 00012 3
877 Vehicle Trim Level 10801 00013 3
unsure if it can be done but any help would be great
Thanks
Robert
I'm in need of some help grouping some data
partNo Qualification SequentialNumber SortOrder Sets
877 Vehicle Equipment 10801 00003 1
877 To construction year 10801 00004 1
877 Block Separation 10801 00005 1
877 To construction year 10801 00006 2
877 Vehicle Equipment 10801 00007 2
877 Vehicle Trim Level 10801 00008 1
877 Vehicle Equipment 10801 00009 3
877 Block Separation 10801 00010 2
877 To construction year 10801 00011 3
877 Vehicle Equipment 10801 00012 4
877 Vehicle Trim Level 10801 00013 2
This is after using
ROW_NUMBER() OVER(PARTITION BY Qualification, SequentialNumber, partNo ORDER BY SortOrder ASC)
What I need is to do is within the qualification can you partition by specifically Block Speration ?
so it would read as follows
partNo Qualification SequentialNumber SortOrder Sets
877 Vehicle Equipment 10801 00003 1
877 To construction year 10801 00004 1
877 Block Separation 10801 00005 1
877 To construction year 10801 00006 2
877 Vehicle Equipment 10801 00007 2
877 Vehicle Trim Level 10801 00008 2
877 Vehicle Equipment 10801 00009 2
877 Block Separation 10801 00010 2
877 To construction year 10801 00011 3
877 Vehicle Equipment 10801 00012 3
877 Vehicle Trim Level 10801 00013 3
unsure if it can be done but any help would be great
Thanks
Robert