Do more with
declare @YourTable table
([GroupID] int, [GroupName] varchar(14), [MenuItemID] int, [MenuItemName] varchar(45))
INSERT INTO @YourTable
([GroupID], [GroupName], [MenuItemID], [MenuItemName])
VALUES
(8, 'Cheese', 25, 'Cheese Pizza (VEG)'),
(8, 'Cheese', 12, 'Bean & Cheese Quesadilla (GF & VEG)'),
(8, 'Cheese', 13, 'Bean & DF Cheese Quesadilla (GF, VEG, & V)'),
(8, 'Cheese', 26, 'Cheese Quesadilla (GF & VEG)'),
(8, 'Cheese', 28, 'Cheese Quesadilla w/ DF Cheese (GF, VEG, & V)'),
(8, 'Cheese', 27, 'Cheese Quesadilla (VEG)'),
(8, 'Cheese', 121, 'Vegetable Quesadilla (VEG)'),
(8, 'Cheese', 122, 'Vegetable Quesadilla w/ DF cheese (VEG & V)'),
(18, 'Grilled Cheese', 64, 'Grilled Cheese on GF Bread (GF & VEG)'),
(18, 'Grilled Cheese', 65, 'Grilled Cheese w/ DF Cheese (VEG & V)'),
(18, 'Grilled Cheese', 63, 'Grilled Cheese (VEG)')
select
MenuName
from (
select distinct GroupName, 0 rn, GroupName as MenuName from @YourTable
union all
select GroupName, 1, ' ' + MenuItemName from @YourTable
) d
order by
GroupName
, rn
, MenuName
Using this sample:
declare @YourTable table
([GroupID] int, [GroupName] varchar(14), [MenuItemID] int, [MenuItemName] varchar(45))
INSERT INTO @YourTable
([GroupID], [GroupName], [MenuItemID], [MenuItemName])
VALUES
(8, 'Cheese', 25, 'Cheese Pizza (VEG)'),
(8, 'Cheese', 12, 'Bean & Cheese Quesadilla (GF & VEG)'),
(8, 'Cheese', 13, 'Bean & DF Cheese Quesadilla (GF, VEG, & V)'),
(8, 'Cheese', 26, 'Cheese Quesadilla (GF & VEG)'),
(8, 'Cheese', 28, 'Cheese Quesadilla w/ DF Cheese (GF, VEG, & V)'),
(8, 'Cheese', 27, 'Cheese Quesadilla (VEG)'),
(8, 'Cheese', 121, 'Vegetable Quesadilla (VEG)'),
(8, 'Cheese', 122, 'Vegetable Quesadilla w/ DF cheese (VEG & V)'),
(18, 'Grilled Cheese', 64, 'Grilled Cheese on GF Bread (GF & VEG)'),
(18, 'Grilled Cheese', 65, 'Grilled Cheese w/ DF Cheese (VEG & V)'),
(18, 'Grilled Cheese', 63, 'Grilled Cheese (VEG)')
the query above produced this result:
MenuName
Cheese
Bean & Cheese Quesadilla (GF & VEG)
Bean & DF Cheese Quesadilla (GF, VEG, & V)
Cheese Pizza (VEG)
Cheese Quesadilla (GF & VEG)
Cheese Quesadilla (VEG)
Cheese Quesadilla w/ DF Cheese (GF, VEG, & V)
Vegetable Quesadilla (VEG)
Vegetable Quesadilla w/ DF cheese (VEG & V)
Grilled Cheese
Grilled Cheese (VEG)
Grilled Cheese on GF Bread (GF & VEG)
Grilled Cheese w/ DF Cheese (VEG & V)
Premium Content
You need an Expert Office subscription to comment.Start Free Trial