April 26, 2007 at 10:37 am
Thanks Carl for the reply. Here is the sample data and DDL.
CREATE TABLE [Group] (
[PkID] [int] IDENTITY (1, 1) NOT NULL ,
[Desc] [nvarchar] (30) COLLATE SQL_1xCompat_CP850_CI_AS NULL ,
[Type] [int] NULL ,
[GroupID] [int] NULL ,
) ON [PRIMARY]
GO
CREATE TABLE [Product] (
[PkID] [int] IDENTITY (1, 1) NOT NULL ,
[Desc] [nvarchar] (30) COLLATE SQL_1xCompat_CP850_CI_AS NULL ,
[Code] [nvarchar] (24) COLLATE SQL_1xCompat_CP850_CI_AS NULL ,
[GroupID] [int] NULL ,
) ON [PRIMARY]
GO
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (1,'Hot drinks',0,23);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (2,'Cold drinks',0,23);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (3,'Snacks',0,11);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (4,'Cakes',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (5,'Sandwiches',0,11);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (6,'Crockery',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (7,'Breakfast',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (8,'Bulk coffee',0,1);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (9,'Salad',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (10,'Others',0,0);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (11,'Light Meals',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (12,'Side Orders',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (13,'Main Courses',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (14,'Desserts',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (15,'Wine',0,26);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (16,'Beer',0,26);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (17,'Specials',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (18,'Spirits',0,26);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (19,'Muffins',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (20,'Kid Meals',0,22);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (21,'Unassigned',0,10);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (22,'Food',0,0);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (23,'Drinks',0,0);
INSERT INTO Group(PkID,Desc,Type,GroupID) VALUES (26,'Alcohol',0,23);
PRODUCT
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (696,'CAPPUCCINO CUP',1,8);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (697,'PLUNGER STYLE',10,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (698,'CROISSANT',100,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (699,'MEGA EXTRA',1000,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (700,'BREAKFAST SPEC',10000,17);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (701,'AFTERNOON SPEC',10001,17);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (702,'CAKE + COKE',10002,17);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (703,'COFFEE SPECIAL',10003,17);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (704,'ESPRESSO GELATO',1001,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (705,'FRUIT FRAPPE',1002,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (706,'MALT EXTRA',1003,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (707,'SCONE',1004,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (708,'HALF MELT',1005,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (709,'MELT',1006,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (710,'PLAIN CROSS.',1007,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (711,'POTATO',1008,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (712,'TOAST EXTRA',1009,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (713,'RAISIN TOAST',101,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (714,'EGG EXTRA',1010,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (715,'CHEESE EXTRA',1012,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (716,'AA EXTRA',1013,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (717,'APPLE SLICE',1014,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (718,'MELT 2 SLICES',1015,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (719,'MUD CAKE',1016,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (720,'CARAMEL BUTTON',1017,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (721,'DATE LOAF',1018,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (722,'ICE CREAM EXTRA',1019,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (723,'TOAST',102,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (724,'FRIES - SIDE',1020,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (725,'FRIES',1021,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (726,'BURRITO',1022,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (727,'CREPE',1023,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (728,'BURGER',1025,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (729,'VEGE PIE',1026,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (730,'FILO DELUXE',1027,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (731,'CHICKEN PIE',1028,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (732,'VEGE ROLL',1029,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (733,'MUFFIN',103,19);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (734,'FILO TRIANGLE',1030,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (735,'PIE 2',1031,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (736,'EXTRA GUACAMOLE',1032,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (737,'EXTRA SAUCE',1034,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (738,'EXTRA SOUR CREAM',1035,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (739,'DIPS & PATE',1036,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (740,'BURGER & SALAD',1037,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (741,'CHICKEN SPEC',1038,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (742,'PIE AUSSIE',1039,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (743,'DEVONSHIRE TEA',104,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (744,'PIE B.B.',1040,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (745,'PIE STEAK MUSH',1041,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (746,'PASTIE PICON.',1042,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (747,'PASTIE CORNISH',1043,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (748,'CHEESE VEG ROLL',1044,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (749,'SPINACH RIC TRI',1045,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (750,'CHICKEN BURRITO',1046,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (751,'BEEF BURRITO',1047,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (752,'CROISSANT SAV',105,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (753,'BACON & EGGS',106,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (754,'SCRAMBLE EGGS',107,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (755,'OMELETTE',108,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (756,'EGGS BENEDICT',109,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (757,'POT OF TEA',11,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (758,'BIG BREAKFAST',110,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (759,'MUGACCINO',1100,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (760,'WRAPS',1101,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (761,'PIDE BREAD',1102,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (762,'BAGUETTE',1103,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (763,'TOM,FETTA&SALAD',1104,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (764,'CAESAR SAL SML',1106,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (765,'PEP. BEEF SALAD',1107,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (766,'CHEESE TART',1108,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (767,'ANTIPASTO SML',1109,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (768,'1 SCONE',111,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (769,'WONTONS SML',1110,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (770,'LINGUINI SML',1111,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (771,'PUMPKIN RIS SML',1112,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (772,'PRAWN RIS SML',1113,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (773,'FLAT WH + MUFFIN',1114,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (774,'CAPP + MUFFIN',1115,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (775,'LONG BL + MUFFIN',1116,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (776,'LATTE + MUFFIN',1117,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (777,'HOT CH + MUFFIN',1118,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (778,'GARLIC BREAD',1119,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (779,'DANISH',112,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (780,'BRUSCHETTA',1120,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (781,'GREEK SALAD',1121,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (782,'HOKKIEN NOODLES',1122,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (783,'TURKISH',1123,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (784,'PENNE',1124,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (785,'BOWTIE',1125,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (786,'WARM BEEF SALAD',1126,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (787,'FRUIT PLATTER',113,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (788,'SAUTEED MUSHRM',114,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (789,'MUESLI',115,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (790,'COMBO 1',116,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (791,'FRUIT BREAD',117,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (792,'COMBO 2',118,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (793,'MUFFIN & COFFEE',119,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (794,'HERBAL TEA',12,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (795,'SPANISH OMELETTE',120,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (796,'MIX LEAF SALAD',1200,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (797,'EXTRA BACON',12000,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (798,'EXTRA MUSHROOM',12001,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (799,'EXTRA TOMATO',12002,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (800,'EXTRA HASH BR',12003,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (801,'ZUCCHINI CHIPS',1201,12);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (802,'WEDGES SOUR CR',1202,12);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (803,'WEDGES',1203,12);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (804,'ROAST VEGES',1204,12);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (805,'HERB BREAD',1205,12);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (806,'MUFFIN BLUEBERRY',1206,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (807,'MUFFIN APPLE',1207,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (808,'MUFFIN CHOCOLATE',1208,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (809,'MUFFIN BANANA',1209,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (810,'FRENCH TOAST',121,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (811,'FRIED',122,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (812,'POACHED',123,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (813,'LUNCH EXTRAS',1236,12);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (814,'SCRAMBLED',124,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (815,'TOAST TURK BREAD',125,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (816,'TROPICAL FRUIT',126,11);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (817,'JAMAICAN',127,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (818,'SCRAMBLED EGGS',128,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (819,'FRUIT JUICE',129,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (820,'FLAT WHITE CUP',13,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (821,'BREAKFAST',130,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (822,'CHICKEN ROULADE',1300,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (823,'FISH FILLET',1301,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (824,'BEEF TENDERLOIN',1302,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (825,'VEAL CUTLET',1303,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (826,'CAJUN PORK',1304,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (827,'2 RAISIN TOAST',131,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (828,'SAVOURY MUFFIN',133,19);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (829,'4 PACK MUFFIN',134,19);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (830,'BLT SANDWICH',135,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (831,'RARE',1350,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (832,'MEDIUM RARE',1351,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (833,'MEDIUM',1352,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (834,'MEDIUM WELL DONE',1353,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (835,'WELL DONE',1354,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (836,'WONTONS LRG',1355,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (837,'ANTIPASTO LRG',1356,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (838,'LINGUINI LRG',1357,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (839,'PRAWN RIS LRG',1358,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (840,'PUMPKIN RIS LRG',1359,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (841,'BACON EGG S/W',136,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (842,'CAESAR SAL LRG',1360,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (843,'BLUE',1361,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (844,'CHICKEN BREAST',1362,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (845,'MEZZE SMALL',1363,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (846,'MEZZE LARGE',1364,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (847,'STIR FRIED VEGES',1365,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (848,'VEAL MARSALA',1366,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (849,'SATAY CHICKEN',1367,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (850,'RISOTTO',1368,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (851,'SCONE JAM CRM',137,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (852,'LINGUINI',1374,13);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (853,'HEART MUFFIN',138,19);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (854,'6 PACK MUFFINS',139,19);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (855,'FLAT WHITE MUG',14,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (856,'CHOC ECLAIR',140,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (857,'CHOC PUDDING',1400,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (858,'PASSION BRULEE',1401,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (859,'LEMON TART',1402,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (860,'MIX DESSERT',1403,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (861,'ICE CREAM SORBET',1404,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (862,'CHEESE & PEARS',1405,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (863,'MUFFIN-',1406,19);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (864,'CROISSANT-',1407,14);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (865,'LOAF',141,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (866,'INCA CHEESECAKE',142,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (867,'RASP CHEESECAKE',143,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (868,'VIENNA TOAST',144,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (869,'DAMPER',145,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (870,'STRAW CHCAKE',146,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (871,'MACADAMIA SL',147,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (872,'PINE PASS TART',148,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (873,'CARAMEL TART',149,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (874,'VIENNA',15,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (875,'QUICHE',150,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (876,'FILO',151,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (877,'GOUMET PIE',152,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (878,'SALAD EXTRA',153,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (879,'INVOLTINI',154,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (880,'SOUP',155,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (881,'FRENCH PIZZA',156,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (882,'CAJUN WEDGES',157,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (883,'LASAGNE',158,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (884,'NACHOS',159,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (885,'MELLOCCINO',16,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (886,'BANANA SPLIT',160,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (887,'VIC BITTER',1601,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (888,'LIGHT ICE',1602,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (889,'FOSTERS',1603,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (890,'CROWN LAGER',1604,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (891,'HOUSE RED',1605,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (892,'HOUSE WHITE',1606,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (893,'SEPPELTS WHITE',1607,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (894,'SEPPELTS RED',1608,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (895,'HARDYS WHITE',1609,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (896,'FRUIT SUNDAE',161,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (897,'HARDYS RED',1610,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (898,'JAMIESONS',1611,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (899,'CARLTON COLD',1612,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (900,'XXXX',1613,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (901,'YELLOWGLEN',1614,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (902,'CHAMPAGNE',1615,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (903,'RIESLING',1616,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (904,'ROSEMOUNT WINE',1617,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (905,'AG RED',1619,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (906,'ICE CREAM- SGL',162,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (907,'AG WHITE',1620,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (908,'CORONA',1621,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (909,'AUST BEER',1622,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (910,'SUB ZERO',1623,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (911,'HAHN LIGHT',1624,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (912,'TOOHEYS DRY',1625,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (913,'HAHN PREM',1626,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (914,'YALUMBA WHITE GL',1627,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (915,'9TH ISLAND GLASS',1628,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (916,'LEHMANN WHT GLAS',1629,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (917,'ICE CREAM- DBL',163,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (918,'YALUMBA WHTE BOT',1630,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (919,'9 ISLAND RED BT',1631,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (920,'LEHMANN WHT BOT',1632,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (921,'YALUMBA RED GL',1633,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (922,'SALMON PATTIES',164,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (923,'HEGGIES WH GL.',1644,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (924,'VOSS WH GLASS',1645,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (925,'LEHMAN RED GL.',1646,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (926,'YALUMBA RED BT.',1647,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (927,'HEGGIES WH BT.',1648,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (928,'VOSS WH BOTT.',1649,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (929,'OTHER MELTS',165,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (930,'LEHMANN RED BT',1650,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (931,'COOPERS',1655,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (932,'HEINEKEN',1656,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (933,'GUINESS',1657,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (934,'CHARD GLASS',1658,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (935,'CHARD BOTTLE',1659,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (936,'SAUSAGE ROLL',166,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (937,'MERLOT GLASS',1660,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (938,'MERLOT BOTTLE',1661,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (939,'PINOT NOIR GLASS',1662,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (940,'PINOT NOIR BOTL',1663,15);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (941,'PASTIES',167,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (942,'TOOHEYS NEW',1670,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (943,'BECKS',1671,16);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (944,'CHILLI',168,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (945,'TORTILLA',169,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (946,'MEGACCINO',17,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (947,'NACHOS FOR 2',170,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (948,'WEDGES FOR 1',171,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (949,'WEDGES FOR 2',172,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (950,'QUICHE & SALAD',173,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (951,'PIE & SALAD',174,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (952,'LASAGNE & SALAD',175,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (953,'PIZZA',176,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (954,'WEDGES EXTRA',177,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (955,'SAVOURY SLICE',178,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (956,'FILO & SALAD',179,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (957,'BABY SHAKE',18,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (958,'CREPE & SALAD',180,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (959,'LEMON RUSKIE',1800,18);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (960,'LIQUEUR COFFEE',1801,18);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (961,'SPIRITS',1802,18);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (962,'SAVOURY POTATO',181,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (963,'CHOCOLATE BAR',182,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (964,'CHOC. INDIVIDUAL',183,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (965,'LUNCH SPECIAL',184,17);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (966,'PIES',185,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (967,'CHOC BEANS',186,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (968,'CHOCOLATES $1',187,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (969,'MISC SNACK',188,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (970,'SPECIAL SNACK',189,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (971,'TEA - CUP',19,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (972,'TORTILLA & SALAD',190,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (973,'APR-PINE WHIP',1900,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (974,'CAPPUCCINO 1.00',1901,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (975,'TANDOORI',191,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (976,'MYSTERY',192,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (977,'VEGETARIAN',193,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (978,'ENCHILADA',194,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (979,'SOUP LARGE',195,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (980,'STRIPS',196,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (981,'1 RAISIN TOAST',197,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (982,'FRIED EGGS',198,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (983,'BANANA BREAD',199,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (984,'CAPPUCCINO MUG',2,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (985,'TEA - MUG',20,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (986,'SANDWICH 1',200,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (987,'DOUBLE SHOT',2000,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (988,'BAGUETTE 1',20000,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (989,'BAGUETTE 2',20001,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (990,'BAGUETTE 3',20002,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (991,'BAGUETTE 4',20003,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (992,'GOLDEN OLDIES',20004,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (993,'TRIPLE DECKER',20005,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (994,'NEW RELEASE',20006,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (995,'MISC SANDWICH',20007,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (996,'1 SLICE TOAST',20008,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (997,'CINN TOAST',20009,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (998,'FRUIT TEA',2001,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (999,'1 FILL SWICH',20010,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1000,'EGG LETTUCE',20011,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1001,'ROAST BEEF SW',20012,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1002,'HAM SW',20013,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1003,'EGG SANDWICH',20014,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1004,'PASTR/CHICK SW',20015,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1005,'SALAD SWICH',20016,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1006,'AVOCADO EXTRA',20017,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1007,'SALMON EXTRA',20018,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1008,'TURKEY S''WICH',20019,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1009,'TAKE AWAY COFFEE',2002,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1010,'MEAT SALAD ROLL',20020,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1011,'EXTRAS 20c',20021,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1012,'EXTRAS 30c',20022,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1013,'EXTRAS 50c',20023,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1014,'EXTRAS 60c',20024,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1015,'EXTRAS 80c',20025,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1016,'EXTRAS $1.00',20026,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1017,'MEAT 1 FILL S/W',20027,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1018,'MEAT S/W',20028,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1019,'CHEESE 1 FILL SW',20029,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1020,'CAPP CUP',2003,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1021,'HAM CHEESE SW',20030,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1022,'MEAT SAL S/W',20031,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1023,'LAVASH',20032,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1024,'CHEESE SANDWICH',20033,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1025,'CHICKEN EXTRA',20034,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1026,'TOAST HCT',20035,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1027,'TOAST CHEESE TOM',20036,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1028,'TOAST HAM TOM',20037,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1029,'EASY BITE',20038,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1030,'TOAST SALAMI',20039,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1031,'ESPRESSO LONG',2004,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1032,'FOC - CHICKEN',20042,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1033,'FOC - SALMON',20043,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1034,'SPINACH PIDE',20044,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1035,'OPEN GRILL 1',20046,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1036,'OPEN GRILL 2',20047,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1037,'MEAT WRAP',20048,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1038,'VEGE WRAP',20049,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1039,'T/A COFFEE SML',2006,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1040,'T/A COFFEE LRG',2007,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1041,'DOUBLE ESPRESSO',2009,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1042,'SANDWICH 2',201,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1043,'LIQ IRISH COFFEE',2010,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1044,'LIQ MEXICAN COFF',2011,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1045,'LIQ JAMAICAN COF',2012,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1046,'LIQ ROMAN COFFEE',2013,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1047,'LIQ BAILEYS COFF',2014,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1048,'DECAF LATTE',2015,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1049,'SKINNY LATTE',2016,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1050,'FLAV COFFEE',2017,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1051,'EXTRA SHOT',2018,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1052,'SANDWICH 3',202,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1053,'CAPP EURO',2020,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1054,'FLAT WHITE EURO',2021,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1055,'LATTE EURO',2022,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1056,'LONG BLK EURO',2023,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1057,'EURO MUG',2024,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1058,'EURO SPEC',2025,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1059,'CAPP MUG',2026,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1060,'BARBACCIENE',2027,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1061,'HOT CHOC MUG',2028,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1062,'SANDWICH 4',203,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1063,'SANDWICH 5',204,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1064,'SANDWICH 6',205,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1065,'SANDWICH 7',206,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1066,'SANDWICH 8',207,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1067,'SANDWICH 9',208,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1068,'PANINI 1',209,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1069,'TEA SPECIAL',21,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1070,'PANINI 2',210,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1071,'PLU 1',2101,21);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1072,'PLU 2',2102,21);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1073,'PLU 3',2103,21);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1074,'PANINI 3',211,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1075,'PANINI 4',212,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1076,'PANINI 5',213,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1077,'PANINI 6',214,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1078,'PANINI 7',215,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1079,'PANINI 8',216,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1080,'PANINI 9',217,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1081,'FINGERS',218,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1082,'REGGAE - 2 SL.',219,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1083,'MACHIATO LONG',22,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1084,'BABY-CINO',2200,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1085,'BABY-SHAKE',2201,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1086,'CHILDS POPPER',2202,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1087,'BABY SPIDER',2203,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1088,'HAM PIZZA',2204,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1089,'HAM PINE PIZZA',2205,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1090,'CHEESE PIZZA',2206,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1091,'KIDS WEDGES',2207,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1092,'KID SWICH 1',2208,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1093,'KIDS SWICH 2',2209,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1094,'KIDS BAN SPLIT',2210,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1095,'1 SCOOP',2211,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1096,'2 SCOOP',2212,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1097,'SNAKE ICE CREAM',2213,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1098,'JELLY BEAN I-C',2214,20);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1099,'SPICED COFFEE',23,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1100,'FREE CAPPUCINO',24,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1101,'FRENCH',25,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1102,'JAMAICAN TOAST',250,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1103,'BERMUDA MELT',251,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1104,'CALYPSO MELT',252,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1105,'REGGAE MELT',253,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1106,'OASIS MELT',254,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1107,'CARIBBEAN',255,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1108,'CLUB SANDWICH',256,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1109,'FOCCACCIA 1',257,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1110,'FOCCACCIA 2',258,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1111,'FOCCACCIA 3',259,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1112,'MOCHA KENYA',26,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1113,'FOCCACCIA 4',260,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1114,'FOCCACCIA 5',261,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1115,'FOCCACCIA 6',262,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1116,'FOCCACCIA 7',263,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1117,'FOCCACCIA 8',264,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1118,'FOCCACCIA 9',265,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1119,'TURKISH BREAD 1',266,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1120,'TURKISH BREAD 2',267,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1121,'TURKISH BREAD 3',268,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1122,'TURKISH BREAD 4',269,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1123,'COLUMBIAN',27,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1124,'TURKISH BREAD 5',270,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1125,'TURKISH BREAD 6',271,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1126,'TURKISH BREAD 7',272,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1127,'TURKISH BREAD 8',273,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1128,'TURKISH BREAD 9',274,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1129,'BAGEL 1',275,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1130,'BAGEL 2',276,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1131,'BAGEL 3',277,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1132,'BAGEL 4',278,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1133,'BAGEL 5',279,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1134,'DECAF',28,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1135,'BAGEL 6',280,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1136,'BAGEL 7',281,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1137,'BAGEL 8',282,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1138,'BAGEL 9',283,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1139,'BAHAMA MELT',284,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1140,'CALYPSO- 2 SLICE',285,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1141,'BERMUDA -2 SLICE',286,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1142,'CARRIBBEAN -2 SL',287,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1143,'BAHAMA - 2 SLICE',288,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1144,'CAFE CLASSIC',289,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1145,'ROYAL MOCHA',29,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1146,'RAJA TANDOORI',290,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1147,'TROPICAL',291,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1148,'RAINFOREST',293,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1149,'ROLL',294,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1150,'BAG 1',295,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1151,'BAG 2',296,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1152,'BAG 3',297,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1153,'OPEN GRL. 2',298,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1154,'GRILL OPEN',299,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1155,'CAFE LATTE',3,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1156,'CARRIBEAN',30,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1157,'CAKES',300,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1158,'TAKE-AWAY',3000,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1159,'BISCUITS',30000,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1160,'CAKE + COFFEE',30001,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1161,'VIENNA TORTE SL',30002,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1162,'VANILLA SL',30003,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1163,'BEE STING',30004,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1164,'POPPY SEED',30005,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1165,'BLACK FOREST',30006,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1166,'TIRA MISU',30007,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1167,'LEMON MERANG',30008,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1168,'HORSE SHOE',30009,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1169,'ENTREE',3001,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1170,'JAFFA CAKE',30010,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1171,'APPLE CRUMBLE',30011,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1172,'WAFFLE',30012,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1173,'FLORENTINE',30013,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1174,'GINGER MAN',30014,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1175,'MACADAM COOKIE',30015,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1176,'ALMOND FINGER',30016,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1177,'MINCE TART',30017,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1178,'LARGE MAC COOKIE',30018,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1179,'FRIAND',30019,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1180,'SHORTBREAD 1',301,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1181,'SHORTBREAD 2',302,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1182,'MILKSHAKE SML',3020,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1183,'THICKSHAKE',3021,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1184,'ICED COFF LO CAL',3022,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1185,'POPPER',3023,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1186,'BOTTLE JUICE LRG',3025,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1187,'ICED CARRIB.',3026,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1188,'BANANA SMOOTHIE',3027,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1189,'STRAW SMOOTHIE',3028,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1190,'MANGO SMOOTHIE',3029,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1191,'SHORTBREAD 3',303,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1192,'ISLAND SMOOTHIE',3030,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1193,'ORANGE PWRADE',3033,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1194,'NATURICE',3034,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1195,'LEMON LIME PWRAD',3035,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1196,'BERRY PWRADE',3036,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1197,'APPLE JUICE',3037,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1198,'TOMATO JUICE',3038,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1199,'PINEAPPLE JUICE',3039,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1200,'APPLE BLACK JUIC',3040,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1201,'PEACH MANGO JUIC',3041,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1202,'600ML COKE',3042,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1203,'600ML DIET COKE',3043,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1204,'CAN COKE',3044,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1205,'CAN DIET COKE',3045,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1206,'CAN LEM LIME ORG',3046,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1207,'CAN ORANGE MANGO',3047,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1208,'GLASS MILK LRG',3048,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1209,'SWEETS',305,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1210,'CARROT CAKE',306,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1211,'SLICE OF LIFE',307,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1212,'VEGE. SLICE',308,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1213,'CHERRY LOAF',309,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1214,'ITALIAN',31,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1215,'TAHITIAN CH CAKE',310,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1216,'CARAMEL SLICE',311,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1217,'MIX NUT SLICE',312,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1218,'CITRUS TART',313,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1219,'CHOC BROWNIE',314,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1220,'TRUFFLE LOG',315,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1221,'CHOC JAFFA CAKE',316,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1222,'COOKIES',317,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1223,'CAKE 1',318,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1224,'CAKE 2',319,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1225,'NEW GUINEA GOLD',32,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1226,'CAKE 3',320,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1227,'CAKE 4',321,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1228,'SLICE 1',322,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1229,'SLICE 2',323,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1230,'SLICE 3',324,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1231,'SLICE 4',325,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1232,'SHORTBREAD 4',326,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1233,'CHEESE CAKE SL.',327,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1234,'MILLE FEVILLE',328,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1235,'SACHER TORTE SL.',329,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1236,'SHORT BLACK',33,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1237,'TARTS',330,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1238,'COINTREAU',331,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1239,'ALMOND CROISSANT',333,7);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1240,'HOT APPLE STRUDL',334,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1241,'CHEESE CAKE SML',335,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1242,'PASTRY',336,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1243,'CAKE ROLL',337,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1244,'TORTES',338,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1245,'BISCOTTI',339,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1246,'LONG BLACK',34,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1247,'CONT CHEESE CAKE',340,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1248,'EXTRA JAM CREAM',341,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1249,'FERRERO',342,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1250,'YO YOS',343,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1251,'BAR LOAVES',344,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1252,'HEALTH CAKES',345,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1253,'APRICOT DELIGHT',346,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1254,'DECAF EXTRA',35,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1255,'APPLE PIE',351,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1256,'ORANGE AL CAKE',352,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1257,'COOKIES LRG',353,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1258,'CHOC CAR MOUSSE',354,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1259,'SNAILS',355,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1260,'TARTS 2',356,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1261,'GERMAN APP CAKE',357,4);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1262,'BABYCINO',36,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1263,'RISTRETTO',37,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1264,'CAFE AFFOGATE',38,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1265,'SOFT DRINK',39,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1266,'RICE',399,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1267,'ESPRESSO',4,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1268,'MUG EXTRA',40,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1269,'BLACKBOARD SP',400,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1270,'SPECIAL',401,5);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1271,'MISCELLANEOUS',402,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1272,'SPAGH. I/CREAM',403,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1273,'T-SHIRTS',404,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1274,'SEE CASHIER',405,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1275,'DRINKS WITH MEAL',406,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1276,'SKIM MILK',41,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1277,'EXTRAS',410,10);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1278,'ENGLISH BREAK',42,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1279,'EARL GREY',43,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1280,'COFFEE BAG',432,8);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1281,'CHOCOLATES',44,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1282,'REFILL',45,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1283,'COFFEE BRICK',450,8);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1284,'COFFEE BEANS KG',451,8);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1285,'MARSHM SPOON',46,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1286,'CHOCOLATE SP',47,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1287,'STAFF COFFEE',49,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1288,'MACCHIATO',5,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1289,'ICED COFFEE',50,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1290,'CROCKERY',500,6);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1291,'ICE CREAM SODA',5000,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1292,'GRANITA',5001,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1293,'300ML BOTTLE',5002,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1294,'FRUIT NECTARS',5003,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1295,'ITALIAN SOFT DRK',5004,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1296,'GLASSOSA',5005,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1297,'ARANCIATA',5006,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1298,'BITTERS',5007,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1299,'PEACH NECT',5008,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1300,'APPLE NECT',5009,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1301,'CROCKERY SM',501,6);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1302,'APRICOT NECT',5010,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1303,'PEAR NECT',5011,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1304,'BANANA MSHAKE',5012,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1305,'ENERGY COCKTAIL',5013,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1306,'EXTRA HERBAL',5014,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1307,'LEMON LIME BITT',5015,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1308,'COOLER',5016,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1309,'LEMONADE',5017,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1310,'GLASS MILK',5018,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1311,'SPRITZ',5019,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1312,'CROCKERY MED',502,6);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1313,'CLASSIC APP BL',5020,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1314,'CLASSIC AP PINE',5021,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1315,'CLASSIC AP PAS',5022,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1316,'RASPBERRY ES',5023,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1317,'CLASSIC TROP',5024,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1318,'LEMON LIME ES',5025,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1319,'PASSION ES',5026,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1320,'LIFT PLUS',5027,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1321,'ICED JAMAICAN',5028,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1322,'VITAMIN C HITS',5029,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1323,'CROCKERY LRG',503,6);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1324,'T/A SOFT DRINK',5030,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1325,'ICED CHOCOLATE',51,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1326,'ICED MOCHA',52,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1327,'ICED TEA',53,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1328,'SMOOTHIE',54,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1329,'TOUCAN SHARE-SM',55,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1330,'TOUCAN SHARE-LG',56,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1331,'SPIDER',57,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1332,'ORANGE JUICE- SM',58,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1333,'ORANGE JUICE- LG',59,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1334,'CAFE VIENNA',6,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1335,'SOY MILK EXTRA',60,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1336,'390ML BOTTLE',61,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1337,'600ML BOTTLE',62,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1338,'600ML WATER',63,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1339,'BOTTLED JUICE',64,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1340,'MINERAL WATER',65,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1341,'JUMPY MONKEY',67,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1342,'JAM ICED COFFEE',68,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1343,'FROZEN CAPP',69,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1344,'HOT CHOCOLATE',7,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1345,'MILKSHAKE',70,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1346,'SUNDAE',71,3);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1347,'375ML CAN',72,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1348,'BOTTLE WATER',73,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1349,'LO-CAL ICED COFF',74,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1350,'ICED FRUIT TEA',75,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1351,'MOCHA YOGHURT',76,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1352,'FRESH P/APPLE JC',77,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1353,'FROZ. CAPP',78,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1354,'CAFE SPECIALE',8,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1355,'500ML MIN WATER',80,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1356,'250ML MIN WATER',81,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1357,'CHINOTTO',82,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1358,'CHOC MILKSHAKE',83,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1359,'VAN MILKSHAKE',84,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1360,'CARAML MILKSHAKE',85,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1361,'STRBRY MILKSHAKE',86,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1362,'LIMONATA',87,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1363,'COKE',88,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1364,'DIET COKE',89,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1365,'CAFE MOCHA',9,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1366,'FANTA',90,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1367,'GARDEN SALAD',900,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1368,'CAESAR SALAD',901,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1369,'TROPICAL CHICKEN',902,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1370,'CHICKEN CAESAR',903,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1371,'GREEK SALAD',904,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1372,'GREEK SALAD-LRG',905,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1373,'GARDEN SALAD-LRG',906,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1374,'CAESAR SALAD-LRG',907,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1375,'CHICK CAESAR-LRG',908,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1376,'SALAD SMALL',909,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1377,'SPRITE',91,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1378,'SALAD LARGE',910,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1379,'FRUIT PACK',911,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1380,'FRUIT SALAD',912,9);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1381,'LIFT',92,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1382,'STRONG',93,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1383,'WEAK',94,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1384,'OTHER DRINK',95,2);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1385,'PEPPERMINT TEA',96,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1386,'CHAMOMILE',97,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1387,'BLUE LAGOON',98,1);
INSERT INTO Product(PkID,Desc,Code,GroupID) VALUES (1388,'DARJEELING BLEND',99,1);
Thanks.
April 27, 2007 at 3:40 pm
Any help would be greatly appreciated. Thanks.
April 29, 2007 at 1:56 pm
Please.......any suggestions to accomplish this. Thanks in advance.
April 30, 2007 at 8:42 pm
Any suggestions. Thanks in advance.
May 2, 2007 at 8:12 pm
Please help. Thanks
May 7, 2007 at 7:11 pm
Any help would be greatly appreciated. Thanks.
May 8, 2007 at 9:35 am
Go to today's or yesterday's posted articule on CTE. There is recursive SP (using loop) that may help you since you are still on SQL2000.
May 8, 2007 at 9:09 pm
Please provide the link. Thanks.
May 11, 2007 at 10:36 am
Hi, This link may be help full for you.
http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
------------
Prakash Sawant
http://psawant.blogspot.com
May 11, 2007 at 10:43 pm
Thanks Prakash.
The example in the link shows recursive method using a single table. But in my case the data is present in two tables. Ex.GROUP and PRODUCT.
Any suggestions how to accomplish this.
Thanks in advance.
May 14, 2007 at 1:05 am
How about something like:
DECLARE @Group TABLE (PkID int NOT NULL, Name varchar (30) NULL, Type int NULL, GroupID int NULL)
DECLARE @product TABLE (PkID int NOT NULL, Name varchar (30) NULL, Code varchar (24) NULL, GroupID int NULL)
DECLARE @View TABLE(PkID int, Name varchar(30), GroupID int)
DECLARE @Result TABLE (PkID int, Name varchar(30), GroupID int, Sequence varbinary(6000), Level int)
DECLARE @Temp1 TABLE (A int)
DECLARE @Temp2 TABLE (A int)
INSERT INTO @Group SELECT 1, 'Hot drinks', 0, 23
UNION ALL SELECT 2, 'Cold drinks', 0, 23
UNION ALL SELECT 3, 'Snacks', 0, 11
UNION ALL SELECT 4, 'Cakes', 0, 22
UNION ALL SELECT 5, 'Sandwiches', 0, 11
UNION ALL SELECT 6, 'Crockery', 0, 22
UNION ALL SELECT 7, 'Breakfast', 0, 22
UNION ALL SELECT 8, 'Bulk coffee', 0, 1
UNION ALL SELECT 9, 'Salad', 0, 22
UNION ALL SELECT 10, 'Others', 0, 0
UNION ALL SELECT 11, 'Light Meals', 0, 22
UNION ALL SELECT 12, 'Side Orders', 0, 22
UNION ALL SELECT 13, 'Main Courses', 0, 22
UNION ALL SELECT 14, 'Desserts', 0, 22
UNION ALL SELECT 15, 'Wine', 0, 26
UNION ALL SELECT 16, 'Beer', 0, 26
UNION ALL SELECT 17, 'Specials', 0, 22
UNION ALL SELECT 18, 'Spirits', 0, 26
UNION ALL SELECT 19, 'Muffins', 0, 22
UNION ALL SELECT 20, 'Kid Meals', 0, 22
UNION ALL SELECT 21, 'Unassigned', 0, 10
UNION ALL SELECT 22, 'Food', 0, 0
UNION ALL SELECT 23, 'Drinks', 0, 0
UNION ALL SELECT 26, 'Alcohol', 0, 23
INSERT INTO @product SELECT 696, 'CAPPUCCINO CUP', 1, 8
UNION ALL SELECT 697, 'PLUNGER STYLE', 10, 1
UNION ALL SELECT 698, 'CROISSANT', 100, 7
UNION ALL SELECT 699, 'MEGA EXTRA', 1000, 1
UNION ALL SELECT 700, 'BREAKFAST SPEC', 10000, 17
UNION ALL SELECT 701, 'AFTERNOON SPEC', 10001, 17
UNION ALL SELECT 702, 'CAKE + COKE', 10002, 17
UNION ALL SELECT 703, 'COFFEE SPECIAL', 10003, 17
UNION ALL SELECT 704, 'ESPRESSO GELATO', 1001, 2
UNION ALL SELECT 705, 'FRUIT FRAPPE', 1002, 2
UNION ALL SELECT 706, 'MALT EXTRA', 1003, 2
UNION ALL SELECT 707, 'SCONE', 1004, 3
UNION ALL SELECT 708, 'HALF MELT', 1005, 5
UNION ALL SELECT 709, 'MELT', 1006, 5
UNION ALL SELECT 710, 'PLAIN CROSS.', 1007, 5
UNION ALL SELECT 711, 'POTATO', 1008, 3
UNION ALL SELECT 712, 'TOAST EXTRA', 1009, 5
UNION ALL SELECT 713, 'RAISIN TOAST', 101, 7
UNION ALL SELECT 714, 'EGG EXTRA', 1010, 5
UNION ALL SELECT 715, 'CHEESE EXTRA', 1012, 5
UNION ALL SELECT 716, 'AA EXTRA', 1013, 5
UNION ALL SELECT 717, 'APPLE SLICE', 1014, 4
UNION ALL SELECT 718, 'MELT 2 SLICES', 1015, 5
UNION ALL SELECT 719, 'MUD CAKE', 1016, 4
UNION ALL SELECT 720, 'CARAMEL BUTTON', 1017, 4
UNION ALL SELECT 721, 'DATE LOAF', 1018, 4
UNION ALL SELECT 722, 'ICE CREAM EXTRA', 1019, 4
UNION ALL SELECT 723, 'TOAST', 102, 7
UNION ALL SELECT 724, 'FRIES - SIDE', 1020, 3
UNION ALL SELECT 725, 'FRIES', 1021, 3
UNION ALL SELECT 726, 'BURRITO', 1022, 3
UNION ALL SELECT 727, 'CREPE', 1023, 3
UNION ALL SELECT 728, 'BURGER', 1025, 3
UNION ALL SELECT 729, 'VEGE PIE', 1026, 3
UNION ALL SELECT 730, 'FILO DELUXE', 1027, 3
UNION ALL SELECT 731, 'CHICKEN PIE', 1028, 3
UNION ALL SELECT 732, 'VEGE ROLL', 1029, 3
UNION ALL SELECT 733, 'MUFFIN', 103, 19
UNION ALL SELECT 734, 'FILO TRIANGLE', 1030, 3
UNION ALL SELECT 735, 'PIE 2', 1031, 3
UNION ALL SELECT 736, 'EXTRA GUACAMOLE', 1032, 3
UNION ALL SELECT 737, 'EXTRA SAUCE', 1034, 3
UNION ALL SELECT 738, 'EXTRA SOUR CREAM', 1035, 3
UNION ALL SELECT 739, 'DIPS & PATE', 1036, 3
UNION ALL SELECT 740, 'BURGER & SALAD', 1037, 3
UNION ALL SELECT 741, 'CHICKEN SPEC', 1038, 3
UNION ALL SELECT 742, 'PIE AUSSIE', 1039, 3
UNION ALL SELECT 743, 'DEVONSHIRE TEA', 104, 7
UNION ALL SELECT 744, 'PIE B.B.', 1040, 3
UNION ALL SELECT 745, 'PIE STEAK MUSH', 1041, 3
UNION ALL SELECT 746, 'PASTIE PICON.', 1042, 3
UNION ALL SELECT 747, 'PASTIE CORNISH', 1043, 3
UNION ALL SELECT 748, 'CHEESE VEG ROLL', 1044, 3
UNION ALL SELECT 749, 'SPINACH RIC TRI', 1045, 3
UNION ALL SELECT 750, 'CHICKEN BURRITO', 1046, 3
UNION ALL SELECT 751, 'BEEF BURRITO', 1047, 3
UNION ALL SELECT 752, 'CROISSANT SAV', 105, 7
UNION ALL SELECT 753, 'BACON & EGGS', 106, 7
UNION ALL SELECT 754, 'SCRAMBLE EGGS', 107, 7
UNION ALL SELECT 755, 'OMELETTE', 108, 7
UNION ALL SELECT 756, 'EGGS BENEDICT', 109, 7
UNION ALL SELECT 757, 'POT OF TEA', 11, 1
UNION ALL SELECT 758, 'BIG BREAKFAST', 110, 7
UNION ALL SELECT 759, 'MUGACCINO', 1100, 1
UNION ALL SELECT 760, 'WRAPS', 1101, 11
UNION ALL SELECT 761, 'PIDE BREAD', 1102, 11
UNION ALL SELECT 762, 'BAGUETTE', 1103, 11
UNION ALL SELECT 763, 'TOM, FETTA&SALAD', 1104, 11
UNION ALL SELECT 764, 'CAESAR SAL SML', 1106, 11
UNION ALL SELECT 765, 'PEP. BEEF SALAD', 1107, 11
UNION ALL SELECT 766, 'CHEESE TART', 1108, 11
UNION ALL SELECT 767, 'ANTIPASTO SML', 1109, 11
UNION ALL SELECT 768, '1 SCONE', 111, 7
UNION ALL SELECT 769, 'WONTONS SML', 1110, 11
UNION ALL SELECT 770, 'LINGUINI SML', 1111, 11
UNION ALL SELECT 771, 'PUMPKIN RIS SML', 1112, 11
UNION ALL SELECT 772, 'PRAWN RIS SML', 1113, 11
UNION ALL SELECT 773, 'FLAT WH + MUFFIN', 1114, 11
UNION ALL SELECT 774, 'CAPP + MUFFIN', 1115, 11
UNION ALL SELECT 775, 'LONG BL + MUFFIN', 1116, 11
UNION ALL SELECT 776, 'LATTE + MUFFIN', 1117, 11
UNION ALL SELECT 777, 'HOT CH + MUFFIN', 1118, 11
UNION ALL SELECT 778, 'GARLIC BREAD', 1119, 11
UNION ALL SELECT 779, 'DANISH', 112, 7
UNION ALL SELECT 780, 'BRUSCHETTA', 1120, 11
UNION ALL SELECT 781, 'GREEK SALAD', 1121, 9
UNION ALL SELECT 782, 'HOKKIEN NOODLES', 1122, 11
UNION ALL SELECT 783, 'TURKISH', 1123, 11
UNION ALL SELECT 784, 'PENNE', 1124, 11
UNION ALL SELECT 785, 'BOWTIE', 1125, 11
UNION ALL SELECT 786, 'WARM BEEF SALAD', 1126, 11
UNION ALL SELECT 787, 'FRUIT PLATTER', 113, 7
UNION ALL SELECT 788, 'SAUTEED MUSHRM', 114, 7
UNION ALL SELECT 789, 'MUESLI', 115, 7
UNION ALL SELECT 790, 'COMBO 1', 116, 7
UNION ALL SELECT 791, 'FRUIT BREAD', 117, 7
UNION ALL SELECT 792, 'COMBO 2', 118, 7
UNION ALL SELECT 793, 'MUFFIN & COFFEE', 119, 7
UNION ALL SELECT 794, 'HERBAL TEA', 12, 1
UNION ALL SELECT 795, 'SPANISH OMELETTE', 120, 7
UNION ALL SELECT 796, 'MIX LEAF SALAD', 1200, 9
UNION ALL SELECT 797, 'EXTRA BACON', 12000, 7
UNION ALL SELECT 798, 'EXTRA MUSHROOM', 12001, 7
UNION ALL SELECT 799, 'EXTRA TOMATO', 12002, 7
UNION ALL SELECT 800, 'EXTRA HASH BR', 12003, 7
UNION ALL SELECT 801, 'ZUCCHINI CHIPS', 1201, 12
UNION ALL SELECT 802, 'WEDGES SOUR CR', 1202, 12
UNION ALL SELECT 803, 'WEDGES', 1203, 12
UNION ALL SELECT 804, 'ROAST VEGES', 1204, 12
UNION ALL SELECT 805, 'HERB BREAD', 1205, 12
UNION ALL SELECT 806, 'MUFFIN BLUEBERRY', 1206, 14
UNION ALL SELECT 807, 'MUFFIN APPLE', 1207, 14
UNION ALL SELECT 808, 'MUFFIN CHOCOLATE', 1208, 14
UNION ALL SELECT 809, 'MUFFIN BANANA', 1209, 14
UNION ALL SELECT 810, 'FRENCH TOAST', 121, 7
UNION ALL SELECT 811, 'FRIED', 122, 7
UNION ALL SELECT 812, 'POACHED', 123, 7
UNION ALL SELECT 813, 'LUNCH EXTRAS', 1236, 12
UNION ALL SELECT 814, 'SCRAMBLED', 124, 7
UNION ALL SELECT 815, 'TOAST TURK BREAD', 125, 7
UNION ALL SELECT 816, 'TROPICAL FRUIT', 126, 11
UNION ALL SELECT 817, 'JAMAICAN', 127, 7
UNION ALL SELECT 818, 'SCRAMBLED EGGS', 128, 7
UNION ALL SELECT 819, 'FRUIT JUICE', 129, 2
UNION ALL SELECT 820, 'FLAT WHITE CUP', 13, 1
UNION ALL SELECT 821, 'BREAKFAST', 130, 7
UNION ALL SELECT 822, 'CHICKEN ROULADE', 1300, 13
UNION ALL SELECT 823, 'FISH FILLET', 1301, 13
UNION ALL SELECT 824, 'BEEF TENDERLOIN', 1302, 13
UNION ALL SELECT 825, 'VEAL CUTLET', 1303, 13
UNION ALL SELECT 826, 'CAJUN PORK', 1304, 13
UNION ALL SELECT 827, '2 RAISIN TOAST', 131, 7
UNION ALL SELECT 828, 'SAVOURY MUFFIN', 133, 19
UNION ALL SELECT 829, '4 PACK MUFFIN', 134, 19
UNION ALL SELECT 830, 'BLT SANDWICH', 135, 7
UNION ALL SELECT 831, 'RARE', 1350, 13
UNION ALL SELECT 832, 'MEDIUM RARE', 1351, 13
UNION ALL SELECT 833, 'MEDIUM', 1352, 13
UNION ALL SELECT 834, 'MEDIUM WELL DONE', 1353, 13
UNION ALL SELECT 835, 'WELL DONE', 1354, 13
UNION ALL SELECT 836, 'WONTONS LRG', 1355, 13
UNION ALL SELECT 837, 'ANTIPASTO LRG', 1356, 13
UNION ALL SELECT 838, 'LINGUINI LRG', 1357, 13
UNION ALL SELECT 839, 'PRAWN RIS LRG', 1358, 13
UNION ALL SELECT 840, 'PUMPKIN RIS LRG', 1359, 13
UNION ALL SELECT 841, 'BACON EGG S/W', 136, 7
UNION ALL SELECT 842, 'CAESAR SAL LRG', 1360, 13
UNION ALL SELECT 843, 'BLUE', 1361, 13
UNION ALL SELECT 844, 'CHICKEN BREAST', 1362, 13
UNION ALL SELECT 845, 'MEZZE SMALL', 1363, 13
UNION ALL SELECT 846, 'MEZZE LARGE', 1364, 13
UNION ALL SELECT 847, 'STIR FRIED VEGES', 1365, 13
UNION ALL SELECT 848, 'VEAL MARSALA', 1366, 13
UNION ALL SELECT 849, 'SATAY CHICKEN', 1367, 13
UNION ALL SELECT 850, 'RISOTTO', 1368, 13
UNION ALL SELECT 851, 'SCONE JAM CRM', 137, 4
UNION ALL SELECT 852, 'LINGUINI', 1374, 13
UNION ALL SELECT 853, 'HEART MUFFIN', 138, 19
UNION ALL SELECT 854, '6 PACK MUFFINS', 139, 19
UNION ALL SELECT 855, 'FLAT WHITE MUG', 14, 1
UNION ALL SELECT 856, 'CHOC ECLAIR', 140, 4
UNION ALL SELECT 857, 'CHOC PUDDING', 1400, 14
UNION ALL SELECT 858, 'PASSION BRULEE', 1401, 14
UNION ALL SELECT 859, 'LEMON TART', 1402, 14
UNION ALL SELECT 860, 'MIX DESSERT', 1403, 14
UNION ALL SELECT 861, 'ICE CREAM SORBET', 1404, 14
UNION ALL SELECT 862, 'CHEESE & PEARS', 1405, 14
UNION ALL SELECT 863, 'MUFFIN-', 1406, 19
UNION ALL SELECT 864, 'CROISSANT-', 1407, 14
UNION ALL SELECT 865, 'LOAF', 141, 4
UNION ALL SELECT 866, 'INCA CHEESECAKE', 142, 4
UNION ALL SELECT 867, 'RASP CHEESECAKE', 143, 4
UNION ALL SELECT 868, 'VIENNA TOAST', 144, 7
UNION ALL SELECT 869, 'DAMPER', 145, 7
UNION ALL SELECT 870, 'STRAW CHCAKE', 146, 4
UNION ALL SELECT 871, 'MACADAMIA SL', 147, 4
UNION ALL SELECT 872, 'PINE PASS TART', 148, 4
UNION ALL SELECT 873, 'CARAMEL TART', 149, 4
UNION ALL SELECT 874, 'VIENNA', 15, 1
UNION ALL SELECT 875, 'QUICHE', 150, 3
UNION ALL SELECT 876, 'FILO', 151, 3
UNION ALL SELECT 877, 'GOUMET PIE', 152, 3
UNION ALL SELECT 878, 'SALAD EXTRA', 153, 9
UNION ALL SELECT 879, 'INVOLTINI', 154, 3
UNION ALL SELECT 880, 'SOUP', 155, 3
UNION ALL SELECT 881, 'FRENCH PIZZA', 156, 3
UNION ALL SELECT 882, 'CAJUN WEDGES', 157, 3
UNION ALL SELECT 883, 'LASAGNE', 158, 3
UNION ALL SELECT 884, 'NACHOS', 159, 3
UNION ALL SELECT 885, 'MELLOCCINO', 16, 1
UNION ALL SELECT 886, 'BANANA SPLIT', 160, 3
UNION ALL SELECT 887, 'VIC BITTER', 1601, 16
UNION ALL SELECT 888, 'LIGHT ICE', 1602, 16
UNION ALL SELECT 889, 'FOSTERS', 1603, 16
UNION ALL SELECT 890, 'CROWN LAGER', 1604, 16
UNION ALL SELECT 891, 'HOUSE RED', 1605, 15
UNION ALL SELECT 892, 'HOUSE WHITE', 1606, 15
UNION ALL SELECT 893, 'SEPPELTS WHITE', 1607, 15
UNION ALL SELECT 894, 'SEPPELTS RED', 1608, 15
UNION ALL SELECT 895, 'HARDYS WHITE', 1609, 15
UNION ALL SELECT 896, 'FRUIT SUNDAE', 161, 3
UNION ALL SELECT 897, 'HARDYS RED', 1610, 15
UNION ALL SELECT 898, 'JAMIESONS', 1611, 15
UNION ALL SELECT 899, 'CARLTON COLD', 1612, 16
UNION ALL SELECT 900, 'XXXX', 1613, 16
UNION ALL SELECT 901, 'YELLOWGLEN', 1614, 15
UNION ALL SELECT 902, 'CHAMPAGNE', 1615, 15
UNION ALL SELECT 903, 'RIESLING', 1616, 15
UNION ALL SELECT 904, 'ROSEMOUNT WINE', 1617, 15
UNION ALL SELECT 905, 'AG RED', 1619, 15
UNION ALL SELECT 906, 'ICE CREAM- SGL', 162, 3
UNION ALL SELECT 907, 'AG WHITE', 1620, 15
UNION ALL SELECT 908, 'CORONA', 1621, 16
UNION ALL SELECT 909, 'AUST BEER', 1622, 16
UNION ALL SELECT 910, 'SUB ZERO', 1623, 16
UNION ALL SELECT 911, 'HAHN LIGHT', 1624, 16
UNION ALL SELECT 912, 'TOOHEYS DRY', 1625, 16
UNION ALL SELECT 913, 'HAHN PREM', 1626, 16
UNION ALL SELECT 914, 'YALUMBA WHITE GL', 1627, 15
UNION ALL SELECT 915, '9TH ISLAND GLASS', 1628, 15
UNION ALL SELECT 916, 'LEHMANN WHT GLAS', 1629, 15
UNION ALL SELECT 917, 'ICE CREAM- DBL', 163, 3
UNION ALL SELECT 918, 'YALUMBA WHTE BOT', 1630, 15
UNION ALL SELECT 919, '9 ISLAND RED BT', 1631, 15
UNION ALL SELECT 920, 'LEHMANN WHT BOT', 1632, 15
UNION ALL SELECT 921, 'YALUMBA RED GL', 1633, 15
UNION ALL SELECT 922, 'SALMON PATTIES', 164, 3
UNION ALL SELECT 923, 'HEGGIES WH GL.', 1644, 15
UNION ALL SELECT 924, 'VOSS WH GLASS', 1645, 15
UNION ALL SELECT 925, 'LEHMAN RED GL.', 1646, 15
UNION ALL SELECT 926, 'YALUMBA RED BT.', 1647, 15
UNION ALL SELECT 927, 'HEGGIES WH BT.', 1648, 15
UNION ALL SELECT 928, 'VOSS WH BOTT.', 1649, 15
UNION ALL SELECT 929, 'OTHER MELTS', 165, 3
UNION ALL SELECT 930, 'LEHMANN RED BT', 1650, 15
UNION ALL SELECT 931, 'COOPERS', 1655, 16
UNION ALL SELECT 932, 'HEINEKEN', 1656, 16
UNION ALL SELECT 933, 'GUINESS', 1657, 16
UNION ALL SELECT 934, 'CHARD GLASS', 1658, 15
UNION ALL SELECT 935, 'CHARD BOTTLE', 1659, 15
UNION ALL SELECT 936, 'SAUSAGE ROLL', 166, 3
UNION ALL SELECT 937, 'MERLOT GLASS', 1660, 15
UNION ALL SELECT 938, 'MERLOT BOTTLE', 1661, 15
UNION ALL SELECT 939, 'PINOT NOIR GLASS', 1662, 15
UNION ALL SELECT 940, 'PINOT NOIR BOTL', 1663, 15
UNION ALL SELECT 941, 'PASTIES', 167, 3
UNION ALL SELECT 942, 'TOOHEYS NEW', 1670, 16
UNION ALL SELECT 943, 'BECKS', 1671, 16
UNION ALL SELECT 944, 'CHILLI', 168, 3
UNION ALL SELECT 945, 'TORTILLA', 169, 3
UNION ALL SELECT 946, 'MEGACCINO', 17, 1
UNION ALL SELECT 947, 'NACHOS FOR 2', 170, 3
UNION ALL SELECT 948, 'WEDGES FOR 1', 171, 3
UNION ALL SELECT 949, 'WEDGES FOR 2', 172, 3
UNION ALL SELECT 950, 'QUICHE & SALAD', 173, 3
UNION ALL SELECT 951, 'PIE & SALAD', 174, 3
UNION ALL SELECT 952, 'LASAGNE & SALAD', 175, 3
UNION ALL SELECT 953, 'PIZZA', 176, 3
UNION ALL SELECT 954, 'WEDGES EXTRA', 177, 3
UNION ALL SELECT 955, 'SAVOURY SLICE', 178, 3
UNION ALL SELECT 956, 'FILO & SALAD', 179, 3
UNION ALL SELECT 957, 'BABY SHAKE', 18, 1
UNION ALL SELECT 958, 'CREPE & SALAD', 180, 3
UNION ALL SELECT 959, 'LEMON RUSKIE', 1800, 18
UNION ALL SELECT 960, 'LIQUEUR COFFEE', 1801, 18
UNION ALL SELECT 961, 'SPIRITS', 1802, 18
UNION ALL SELECT 962, 'SAVOURY POTATO', 181, 3
UNION ALL SELECT 963, 'CHOCOLATE BAR', 182, 3
UNION ALL SELECT 964, 'CHOC. INDIVIDUAL', 183, 3
UNION ALL SELECT 965, 'LUNCH SPECIAL', 184, 17
UNION ALL SELECT 966, 'PIES', 185, 3
UNION ALL SELECT 967, 'CHOC BEANS', 186, 10
UNION ALL SELECT 968, 'CHOCOLATES $1', 187, 3
UNION ALL SELECT 969, 'MISC SNACK', 188, 3
UNION ALL SELECT 970, 'SPECIAL SNACK', 189, 3
UNION ALL SELECT 971, 'TEA - CUP', 19, 1
UNION ALL SELECT 972, 'TORTILLA & SALAD', 190, 3
UNION ALL SELECT 973, 'APR-PINE WHIP', 1900, 2
UNION ALL SELECT 974, 'CAPPUCCINO 1.00', 1901, 1
UNION ALL SELECT 975, 'TANDOORI', 191, 3
UNION ALL SELECT 976, 'MYSTERY', 192, 3
UNION ALL SELECT 977, 'VEGETARIAN', 193, 3
UNION ALL SELECT 978, 'ENCHILADA', 194, 3
UNION ALL SELECT 979, 'SOUP LARGE', 195, 3
UNION ALL SELECT 980, 'STRIPS', 196, 3
UNION ALL SELECT 981, '1 RAISIN TOAST', 197, 7
UNION ALL SELECT 982, 'FRIED EGGS', 198, 7
UNION ALL SELECT 983, 'BANANA BREAD', 199, 7
UNION ALL SELECT 984, 'CAPPUCCINO MUG', 2, 1
UNION ALL SELECT 985, 'TEA - MUG', 20, 1
UNION ALL SELECT 986, 'SANDWICH 1', 200, 5
UNION ALL SELECT 987, 'DOUBLE SHOT', 2000, 1
UNION ALL SELECT 988, 'BAGUETTE 1', 20000, 5
UNION ALL SELECT 989, 'BAGUETTE 2', 20001, 5
UNION ALL SELECT 990, 'BAGUETTE 3', 20002, 5
UNION ALL SELECT 991, 'BAGUETTE 4', 20003, 5
UNION ALL SELECT 992, 'GOLDEN OLDIES', 20004, 5
UNION ALL SELECT 993, 'TRIPLE DECKER', 20005, 5
UNION ALL SELECT 994, 'NEW RELEASE', 20006, 5
UNION ALL SELECT 995, 'MISC SANDWICH', 20007, 5
UNION ALL SELECT 996, '1 SLICE TOAST', 20008, 5
UNION ALL SELECT 997, 'CINN TOAST', 20009, 5
UNION ALL SELECT 998, 'FRUIT TEA', 2001, 1
UNION ALL SELECT 999, '1 FILL SWICH', 20010, 5
UNION ALL SELECT 1000, 'EGG LETTUCE', 20011, 5
UNION ALL SELECT 1001, 'ROAST BEEF SW', 20012, 5
UNION ALL SELECT 1002, 'HAM SW', 20013, 5
UNION ALL SELECT 1003, 'EGG SANDWICH', 20014, 5
UNION ALL SELECT 1004, 'PASTR/CHICK SW', 20015, 5
UNION ALL SELECT 1005, 'SALAD SWICH', 20016, 5
UNION ALL SELECT 1006, 'AVOCADO EXTRA', 20017, 5
UNION ALL SELECT 1007, 'SALMON EXTRA', 20018, 5
UNION ALL SELECT 1008, 'TURKEY S''WICH', 20019, 5
UNION ALL SELECT 1009, 'TAKE AWAY COFFEE', 2002, 1
UNION ALL SELECT 1010, 'MEAT SALAD ROLL', 20020, 5
UNION ALL SELECT 1011, 'EXTRAS 20c', 20021, 5
UNION ALL SELECT 1012, 'EXTRAS 30c', 20022, 5
UNION ALL SELECT 1013, 'EXTRAS 50c', 20023, 5
UNION ALL SELECT 1014, 'EXTRAS 60c', 20024, 5
UNION ALL SELECT 1015, 'EXTRAS 80c', 20025, 5
UNION ALL SELECT 1016, 'EXTRAS $1.00', 20026, 5
UNION ALL SELECT 1017, 'MEAT 1 FILL S/W', 20027, 5
UNION ALL SELECT 1018, 'MEAT S/W', 20028, 5
UNION ALL SELECT 1019, 'CHEESE 1 FILL SW', 20029, 5
UNION ALL SELECT 1020, 'CAPP CUP', 2003, 1
UNION ALL SELECT 1021, 'HAM CHEESE SW', 20030, 5
UNION ALL SELECT 1022, 'MEAT SAL S/W', 20031, 5
UNION ALL SELECT 1023, 'LAVASH', 20032, 5
UNION ALL SELECT 1024, 'CHEESE SANDWICH', 20033, 5
UNION ALL SELECT 1025, 'CHICKEN EXTRA', 20034, 5
UNION ALL SELECT 1026, 'TOAST HCT', 20035, 5
UNION ALL SELECT 1027, 'TOAST CHEESE TOM', 20036, 5
UNION ALL SELECT 1028, 'TOAST HAM TOM', 20037, 5
UNION ALL SELECT 1029, 'EASY BITE', 20038, 5
UNION ALL SELECT 1030, 'TOAST SALAMI', 20039, 5
UNION ALL SELECT 1031, 'ESPRESSO LONG', 2004, 1
UNION ALL SELECT 1032, 'FOC - CHICKEN', 20042, 5
UNION ALL SELECT 1033, 'FOC - SALMON', 20043, 5
UNION ALL SELECT 1034, 'SPINACH PIDE', 20044, 5
UNION ALL SELECT 1035, 'OPEN GRILL 1', 20046, 5
UNION ALL SELECT 1036, 'OPEN GRILL 2', 20047, 5
UNION ALL SELECT 1037, 'MEAT WRAP', 20048, 5
UNION ALL SELECT 1038, 'VEGE WRAP', 20049, 5
UNION ALL SELECT 1039, 'T/A COFFEE SML', 2006, 1
UNION ALL SELECT 1040, 'T/A COFFEE LRG', 2007, 1
UNION ALL SELECT 1041, 'DOUBLE ESPRESSO', 2009, 1
UNION ALL SELECT 1042, 'SANDWICH 2', 201, 5
UNION ALL SELECT 1043, 'LIQ IRISH COFFEE', 2010, 1
UNION ALL SELECT 1044, 'LIQ MEXICAN COFF', 2011, 1
UNION ALL SELECT 1045, 'LIQ JAMAICAN COF', 2012, 1
UNION ALL SELECT 1046, 'LIQ ROMAN COFFEE', 2013, 1
UNION ALL SELECT 1047, 'LIQ BAILEYS COFF', 2014, 1
UNION ALL SELECT 1048, 'DECAF LATTE', 2015, 1
UNION ALL SELECT 1049, 'SKINNY LATTE', 2016, 1
UNION ALL SELECT 1050, 'FLAV COFFEE', 2017, 1
UNION ALL SELECT 1051, 'EXTRA SHOT', 2018, 1
UNION ALL SELECT 1052, 'SANDWICH 3', 202, 5
UNION ALL SELECT 1053, 'CAPP EURO', 2020, 1
UNION ALL SELECT 1054, 'FLAT WHITE EURO', 2021, 1
UNION ALL SELECT 1055, 'LATTE EURO', 2022, 1
UNION ALL SELECT 1056, 'LONG BLK EURO', 2023, 1
UNION ALL SELECT 1057, 'EURO MUG', 2024, 1
UNION ALL SELECT 1058, 'EURO SPEC', 2025, 1
UNION ALL SELECT 1059, 'CAPP MUG', 2026, 1
UNION ALL SELECT 1060, 'BARBACCIENE', 2027, 1
UNION ALL SELECT 1061, 'HOT CHOC MUG', 2028, 1
UNION ALL SELECT 1062, 'SANDWICH 4', 203, 5
UNION ALL SELECT 1063, 'SANDWICH 5', 204, 5
UNION ALL SELECT 1064, 'SANDWICH 6', 205, 5
UNION ALL SELECT 1065, 'SANDWICH 7', 206, 5
UNION ALL SELECT 1066, 'SANDWICH 8', 207, 5
UNION ALL SELECT 1067, 'SANDWICH 9', 208, 5
UNION ALL SELECT 1068, 'PANINI 1', 209, 5
UNION ALL SELECT 1069, 'TEA SPECIAL', 21, 1
UNION ALL SELECT 1070, 'PANINI 2', 210, 5
UNION ALL SELECT 1071, 'PLU 1', 2101, 21
UNION ALL SELECT 1072, 'PLU 2', 2102, 21
UNION ALL SELECT 1073, 'PLU 3', 2103, 21
UNION ALL SELECT 1074, 'PANINI 3', 211, 5
UNION ALL SELECT 1075, 'PANINI 4', 212, 5
UNION ALL SELECT 1076, 'PANINI 5', 213, 5
UNION ALL SELECT 1077, 'PANINI 6', 214, 5
UNION ALL SELECT 1078, 'PANINI 7', 215, 5
UNION ALL SELECT 1079, 'PANINI 8', 216, 5
UNION ALL SELECT 1080, 'PANINI 9', 217, 5
UNION ALL SELECT 1081, 'FINGERS', 218, 5
UNION ALL SELECT 1082, 'REGGAE - 2 SL.', 219, 5
UNION ALL SELECT 1083, 'MACHIATO LONG', 22, 1
UNION ALL SELECT 1084, 'BABY-CINO', 2200, 20
UNION ALL SELECT 1085, 'BABY-SHAKE', 2201, 20
UNION ALL SELECT 1086, 'CHILDS POPPER', 2202, 20
UNION ALL SELECT 1087, 'BABY SPIDER', 2203, 20
UNION ALL SELECT 1088, 'HAM PIZZA', 2204, 20
UNION ALL SELECT 1089, 'HAM PINE PIZZA', 2205, 20
UNION ALL SELECT 1090, 'CHEESE PIZZA', 2206, 20
UNION ALL SELECT 1091, 'KIDS WEDGES', 2207, 20
UNION ALL SELECT 1092, 'KID SWICH 1', 2208, 20
UNION ALL SELECT 1093, 'KIDS SWICH 2', 2209, 20
UNION ALL SELECT 1094, 'KIDS BAN SPLIT', 2210, 20
UNION ALL SELECT 1095, '1 SCOOP', 2211, 20
UNION ALL SELECT 1096, '2 SCOOP', 2212, 20
UNION ALL SELECT 1097, 'SNAKE ICE CREAM', 2213, 20
UNION ALL SELECT 1098, 'JELLY BEAN I-C', 2214, 20
UNION ALL SELECT 1099, 'SPICED COFFEE', 23, 1
UNION ALL SELECT 1100, 'FREE CAPPUCINO', 24, 1
UNION ALL SELECT 1101, 'FRENCH', 25, 1
UNION ALL SELECT 1102, 'JAMAICAN TOAST', 250, 5
UNION ALL SELECT 1103, 'BERMUDA MELT', 251, 5
UNION ALL SELECT 1104, 'CALYPSO MELT', 252, 5
UNION ALL SELECT 1105, 'REGGAE MELT', 253, 5
UNION ALL SELECT 1106, 'OASIS MELT', 254, 5
UNION ALL SELECT 1107, 'CARIBBEAN', 255, 5
UNION ALL SELECT 1108, 'CLUB SANDWICH', 256, 5
UNION ALL SELECT 1109, 'FOCCACCIA 1', 257, 5
UNION ALL SELECT 1110, 'FOCCACCIA 2', 258, 5
UNION ALL SELECT 1111, 'FOCCACCIA 3', 259, 5
UNION ALL SELECT 1112, 'MOCHA KENYA', 26, 1
UNION ALL SELECT 1113, 'FOCCACCIA 4', 260, 5
UNION ALL SELECT 1114, 'FOCCACCIA 5', 261, 5
UNION ALL SELECT 1115, 'FOCCACCIA 6', 262, 5
UNION ALL SELECT 1116, 'FOCCACCIA 7', 263, 5
UNION ALL SELECT 1117, 'FOCCACCIA 8', 264, 5
UNION ALL SELECT 1118, 'FOCCACCIA 9', 265, 5
UNION ALL SELECT 1119, 'TURKISH BREAD 1', 266, 5
UNION ALL SELECT 1120, 'TURKISH BREAD 2', 267, 5
UNION ALL SELECT 1121, 'TURKISH BREAD 3', 268, 5
UNION ALL SELECT 1122, 'TURKISH BREAD 4', 269, 5
UNION ALL SELECT 1123, 'COLUMBIAN', 27, 1
UNION ALL SELECT 1124, 'TURKISH BREAD 5', 270, 5
UNION ALL SELECT 1125, 'TURKISH BREAD 6', 271, 5
UNION ALL SELECT 1126, 'TURKISH BREAD 7', 272, 5
UNION ALL SELECT 1127, 'TURKISH BREAD 8', 273, 5
UNION ALL SELECT 1128, 'TURKISH BREAD 9', 274, 5
UNION ALL SELECT 1129, 'BAGEL 1', 275, 5
UNION ALL SELECT 1130, 'BAGEL 2', 276, 5
UNION ALL SELECT 1131, 'BAGEL 3', 277, 5
UNION ALL SELECT 1132, 'BAGEL 4', 278, 5
UNION ALL SELECT 1133, 'BAGEL 5', 279, 5
UNION ALL SELECT 1134, 'DECAF', 28, 1
UNION ALL SELECT 1135, 'BAGEL 6', 280, 5
UNION ALL SELECT 1136, 'BAGEL 7', 281, 5
UNION ALL SELECT 1137, 'BAGEL 8', 282, 5
UNION ALL SELECT 1138, 'BAGEL 9', 283, 5
UNION ALL SELECT 1139, 'BAHAMA MELT', 284, 5
UNION ALL SELECT 1140, 'CALYPSO- 2 SLICE', 285, 5
UNION ALL SELECT 1141, 'BERMUDA -2 SLICE', 286, 5
UNION ALL SELECT 1142, 'CARRIBBEAN -2 SL', 287, 5
UNION ALL SELECT 1143, 'BAHAMA - 2 SLICE', 288, 5
UNION ALL SELECT 1144, 'CAFE CLASSIC', 289, 3
UNION ALL SELECT 1145, 'ROYAL MOCHA', 29, 1
UNION ALL SELECT 1146, 'RAJA TANDOORI', 290, 3
UNION ALL SELECT 1147, 'TROPICAL', 291, 3
UNION ALL SELECT 1148, 'RAINFOREST', 293, 3
UNION ALL SELECT 1149, 'ROLL', 294, 5
UNION ALL SELECT 1150, 'BAG 1', 295, 5
UNION ALL SELECT 1151, 'BAG 2', 296, 5
UNION ALL SELECT 1152, 'BAG 3', 297, 5
UNION ALL SELECT 1153, 'OPEN GRL. 2', 298, 5
UNION ALL SELECT 1154, 'GRILL OPEN', 299, 5
UNION ALL SELECT 1155, 'CAFE LATTE', 3, 1
UNION ALL SELECT 1156, 'CARRIBEAN', 30, 1
UNION ALL SELECT 1157, 'CAKES', 300, 4
UNION ALL SELECT 1158, 'TAKE-AWAY', 3000, 10
UNION ALL SELECT 1159, 'BISCUITS', 30000, 4
UNION ALL SELECT 1160, 'CAKE + COFFEE', 30001, 4
UNION ALL SELECT 1161, 'VIENNA TORTE SL', 30002, 4
UNION ALL SELECT 1162, 'VANILLA SL', 30003, 4
UNION ALL SELECT 1163, 'BEE STING', 30004, 4
UNION ALL SELECT 1164, 'POPPY SEED', 30005, 4
UNION ALL SELECT 1165, 'BLACK FOREST', 30006, 4
UNION ALL SELECT 1166, 'TIRA MISU', 30007, 4
UNION ALL SELECT 1167, 'LEMON MERANG', 30008, 4
UNION ALL SELECT 1168, 'HORSE SHOE', 30009, 4
UNION ALL SELECT 1169, 'ENTREE', 3001, 10
UNION ALL SELECT 1170, 'JAFFA CAKE', 30010, 4
UNION ALL SELECT 1171, 'APPLE CRUMBLE', 30011, 4
UNION ALL SELECT 1172, 'WAFFLE', 30012, 4
UNION ALL SELECT 1173, 'FLORENTINE', 30013, 4
UNION ALL SELECT 1174, 'GINGER MAN', 30014, 4
UNION ALL SELECT 1175, 'MACADAM COOKIE', 30015, 4
UNION ALL SELECT 1176, 'ALMOND FINGER', 30016, 4
UNION ALL SELECT 1177, 'MINCE TART', 30017, 4
UNION ALL SELECT 1178, 'LARGE MAC COOKIE', 30018, 4
UNION ALL SELECT 1179, 'FRIAND', 30019, 4
UNION ALL SELECT 1180, 'SHORTBREAD 1', 301, 4
UNION ALL SELECT 1181, 'SHORTBREAD 2', 302, 4
UNION ALL SELECT 1182, 'MILKSHAKE SML', 3020, 2
UNION ALL SELECT 1183, 'THICKSHAKE', 3021, 2
UNION ALL SELECT 1184, 'ICED COFF LO CAL', 3022, 2
UNION ALL SELECT 1185, 'POPPER', 3023, 2
UNION ALL SELECT 1186, 'BOTTLE JUICE LRG', 3025, 2
UNION ALL SELECT 1187, 'ICED CARRIB.', 3026, 2
UNION ALL SELECT 1188, 'BANANA SMOOTHIE', 3027, 2
UNION ALL SELECT 1189, 'STRAW SMOOTHIE', 3028, 2
UNION ALL SELECT 1190, 'MANGO SMOOTHIE', 3029, 2
UNION ALL SELECT 1191, 'SHORTBREAD 3', 303, 4
UNION ALL SELECT 1192, 'ISLAND SMOOTHIE', 3030, 2
UNION ALL SELECT 1193, 'ORANGE PWRADE', 3033, 2
UNION ALL SELECT 1194, 'NATURICE', 3034, 2
UNION ALL SELECT 1195, 'LEMON LIME PWRAD', 3035, 2
UNION ALL SELECT 1196, 'BERRY PWRADE', 3036, 2
UNION ALL SELECT 1197, 'APPLE JUICE', 3037, 2
UNION ALL SELECT 1198, 'TOMATO JUICE', 3038, 2
UNION ALL SELECT 1199, 'PINEAPPLE JUICE', 3039, 2
UNION ALL SELECT 1200, 'APPLE BLACK JUIC', 3040, 2
UNION ALL SELECT 1201, 'PEACH MANGO JUIC', 3041, 2
UNION ALL SELECT 1202, '600ML COKE', 3042, 2
UNION ALL SELECT 1203, '600ML DIET COKE', 3043, 2
UNION ALL SELECT 1204, 'CAN COKE', 3044, 2
UNION ALL SELECT 1205, 'CAN DIET COKE', 3045, 2
UNION ALL SELECT 1206, 'CAN LEM LIME ORG', 3046, 2
UNION ALL SELECT 1207, 'CAN ORANGE MANGO', 3047, 2
UNION ALL SELECT 1208, 'GLASS MILK LRG', 3048, 2
UNION ALL SELECT 1209, 'SWEETS', 305, 4
UNION ALL SELECT 1210, 'CARROT CAKE', 306, 4
UNION ALL SELECT 1211, 'SLICE OF LIFE', 307, 4
UNION ALL SELECT 1212, 'VEGE. SLICE', 308, 4
UNION ALL SELECT 1213, 'CHERRY LOAF', 309, 4
UNION ALL SELECT 1214, 'ITALIAN', 31, 1
UNION ALL SELECT 1215, 'TAHITIAN CH CAKE', 310, 4
UNION ALL SELECT 1216, 'CARAMEL SLICE', 311, 4
UNION ALL SELECT 1217, 'MIX NUT SLICE', 312, 4
UNION ALL SELECT 1218, 'CITRUS TART', 313, 4
UNION ALL SELECT 1219, 'CHOC BROWNIE', 314, 4
UNION ALL SELECT 1220, 'TRUFFLE LOG', 315, 4
UNION ALL SELECT 1221, 'CHOC JAFFA CAKE', 316, 4
UNION ALL SELECT 1222, 'COOKIES', 317, 4
UNION ALL SELECT 1223, 'CAKE 1', 318, 4
UNION ALL SELECT 1224, 'CAKE 2', 319, 4
UNION ALL SELECT 1225, 'NEW GUINEA GOLD', 32, 1
UNION ALL SELECT 1226, 'CAKE 3', 320, 4
UNION ALL SELECT 1227, 'CAKE 4', 321, 4
UNION ALL SELECT 1228, 'SLICE 1', 322, 4
UNION ALL SELECT 1229, 'SLICE 2', 323, 4
UNION ALL SELECT 1230, 'SLICE 3', 324, 4
UNION ALL SELECT 1231, 'SLICE 4', 325, 4
UNION ALL SELECT 1232, 'SHORTBREAD 4', 326, 4
UNION ALL SELECT 1233, 'CHEESE CAKE SL.', 327, 4
UNION ALL SELECT 1234, 'MILLE FEVILLE', 328, 4
UNION ALL SELECT 1235, 'SACHER TORTE SL.', 329, 4
UNION ALL SELECT 1236, 'SHORT BLACK', 33, 1
UNION ALL SELECT 1237, 'TARTS', 330, 4
UNION ALL SELECT 1238, 'COINTREAU', 331, 4
UNION ALL SELECT 1239, 'ALMOND CROISSANT', 333, 7
UNION ALL SELECT 1240, 'HOT APPLE STRUDL', 334, 4
UNION ALL SELECT 1241, 'CHEESE CAKE SML', 335, 4
UNION ALL SELECT 1242, 'PASTRY', 336, 3
UNION ALL SELECT 1243, 'CAKE ROLL', 337, 4
UNION ALL SELECT 1244, 'TORTES', 338, 4
UNION ALL SELECT 1245, 'BISCOTTI', 339, 4
UNION ALL SELECT 1246, 'LONG BLACK', 34, 1
UNION ALL SELECT 1247, 'CONT CHEESE CAKE', 340, 4
UNION ALL SELECT 1248, 'EXTRA JAM CREAM', 341, 4
UNION ALL SELECT 1249, 'FERRERO', 342, 4
UNION ALL SELECT 1250, 'YO YOS', 343, 4
UNION ALL SELECT 1251, 'BAR LOAVES', 344, 4
UNION ALL SELECT 1252, 'HEALTH CAKES', 345, 4
UNION ALL SELECT 1253, 'APRICOT DELIGHT', 346, 4
UNION ALL SELECT 1254, 'DECAF EXTRA', 35, 1
UNION ALL SELECT 1255, 'APPLE PIE', 351, 4
UNION ALL SELECT 1256, 'ORANGE AL CAKE', 352, 4
UNION ALL SELECT 1257, 'COOKIES LRG', 353, 4
UNION ALL SELECT 1258, 'CHOC CAR MOUSSE', 354, 4
UNION ALL SELECT 1259, 'SNAILS', 355, 4
UNION ALL SELECT 1260, 'TARTS 2', 356, 4
UNION ALL SELECT 1261, 'GERMAN APP CAKE', 357, 4
UNION ALL SELECT 1262, 'BABYCINO', 36, 1
UNION ALL SELECT 1263, 'RISTRETTO', 37, 1
UNION ALL SELECT 1264, 'CAFE AFFOGATE', 38, 1
UNION ALL SELECT 1265, 'SOFT DRINK', 39, 2
UNION ALL SELECT 1266, 'RICE', 399, 3
UNION ALL SELECT 1267, 'ESPRESSO', 4, 1
UNION ALL SELECT 1268, 'MUG EXTRA', 40, 1
UNION ALL SELECT 1269, 'BLACKBOARD SP', 400, 10
UNION ALL SELECT 1270, 'SPECIAL', 401, 5
UNION ALL SELECT 1271, 'MISCELLANEOUS', 402, 10
UNION ALL SELECT 1272, 'SPAGH. I/CREAM', 403, 10
UNION ALL SELECT 1273, 'T-SHIRTS', 404, 10
UNION ALL SELECT 1274, 'SEE CASHIER', 405, 10
UNION ALL SELECT 1275, 'DRINKS WITH MEAL', 406, 10
UNION ALL SELECT 1276, 'SKIM MILK', 41, 1
UNION ALL SELECT 1277, 'EXTRAS', 410, 10
UNION ALL SELECT 1278, 'ENGLISH BREAK', 42, 1
UNION ALL SELECT 1279, 'EARL GREY', 43, 1
UNION ALL SELECT 1280, 'COFFEE BAG', 432, 8
UNION ALL SELECT 1281, 'CHOCOLATES', 44, 1
UNION ALL SELECT 1282, 'REFILL', 45, 1
UNION ALL SELECT 1283, 'COFFEE BRICK', 450, 8
UNION ALL SELECT 1284, 'COFFEE BEANS KG', 451, 8
UNION ALL SELECT 1285, 'MARSHM SPOON', 46, 1
UNION ALL SELECT 1286, 'CHOCOLATE SP', 47, 1
UNION ALL SELECT 1287, 'STAFF COFFEE', 49, 1
UNION ALL SELECT 1288, 'MACCHIATO', 5, 1
UNION ALL SELECT 1289, 'ICED COFFEE', 50, 2
UNION ALL SELECT 1290, 'CROCKERY', 500, 6
UNION ALL SELECT 1291, 'ICE CREAM SODA', 5000, 2
UNION ALL SELECT 1292, 'GRANITA', 5001, 2
UNION ALL SELECT 1293, '300ML BOTTLE', 5002, 2
UNION ALL SELECT 1294, 'FRUIT NECTARS', 5003, 2
UNION ALL SELECT 1295, 'ITALIAN SOFT DRK', 5004, 2
UNION ALL SELECT 1296, 'GLASSOSA', 5005, 2
UNION ALL SELECT 1297, 'ARANCIATA', 5006, 2
UNION ALL SELECT 1298, 'BITTERS', 5007, 2
UNION ALL SELECT 1299, 'PEACH NECT', 5008, 2
UNION ALL SELECT 1300, 'APPLE NECT', 5009, 2
UNION ALL SELECT 1301, 'CROCKERY SM', 501, 6
UNION ALL SELECT 1302, 'APRICOT NECT', 5010, 2
UNION ALL SELECT 1303, 'PEAR NECT', 5011, 2
UNION ALL SELECT 1304, 'BANANA MSHAKE', 5012, 2
UNION ALL SELECT 1305, 'ENERGY COCKTAIL', 5013, 2
UNION ALL SELECT 1306, 'EXTRA HERBAL', 5014, 2
UNION ALL SELECT 1307, 'LEMON LIME BITT', 5015, 2
UNION ALL SELECT 1308, 'COOLER', 5016, 2
UNION ALL SELECT 1309, 'LEMONADE', 5017, 2
UNION ALL SELECT 1310, 'GLASS MILK', 5018, 2
UNION ALL SELECT 1311, 'SPRITZ', 5019, 2
UNION ALL SELECT 1312, 'CROCKERY MED', 502, 6
UNION ALL SELECT 1313, 'CLASSIC APP BL', 5020, 2
UNION ALL SELECT 1314, 'CLASSIC AP PINE', 5021, 2
UNION ALL SELECT 1315, 'CLASSIC AP PAS', 5022, 2
UNION ALL SELECT 1316, 'RASPBERRY ES', 5023, 2
UNION ALL SELECT 1317, 'CLASSIC TROP', 5024, 2
UNION ALL SELECT 1318, 'LEMON LIME ES', 5025, 2
UNION ALL SELECT 1319, 'PASSION ES', 5026, 2
UNION ALL SELECT 1320, 'LIFT PLUS', 5027, 2
UNION ALL SELECT 1321, 'ICED JAMAICAN', 5028, 2
UNION ALL SELECT 1322, 'VITAMIN C HITS', 5029, 2
UNION ALL SELECT 1323, 'CROCKERY LRG', 503, 6
UNION ALL SELECT 1324, 'T/A SOFT DRINK', 5030, 2
UNION ALL SELECT 1325, 'ICED CHOCOLATE', 51, 2
UNION ALL SELECT 1326, 'ICED MOCHA', 52, 2
UNION ALL SELECT 1327, 'ICED TEA', 53, 2
UNION ALL SELECT 1328, 'SMOOTHIE', 54, 2
UNION ALL SELECT 1329, 'TOUCAN SHARE-SM', 55, 2
UNION ALL SELECT 1330, 'TOUCAN SHARE-LG', 56, 2
UNION ALL SELECT 1331, 'SPIDER', 57, 2
UNION ALL SELECT 1332, 'ORANGE JUICE- SM', 58, 2
UNION ALL SELECT 1333, 'ORANGE JUICE- LG', 59, 2
UNION ALL SELECT 1334, 'CAFE VIENNA', 6, 1
UNION ALL SELECT 1335, 'SOY MILK EXTRA', 60, 2
UNION ALL SELECT 1336, '390ML BOTTLE', 61, 2
UNION ALL SELECT 1337, '600ML BOTTLE', 62, 2
UNION ALL SELECT 1338, '600ML WATER', 63, 2
UNION ALL SELECT 1339, 'BOTTLED JUICE', 64, 2
UNION ALL SELECT 1340, 'MINERAL WATER', 65, 2
UNION ALL SELECT 1341, 'JUMPY MONKEY', 67, 2
UNION ALL SELECT 1342, 'JAM ICED COFFEE', 68, 2
UNION ALL SELECT 1343, 'FROZEN CAPP', 69, 2
UNION ALL SELECT 1344, 'HOT CHOCOLATE', 7, 1
UNION ALL SELECT 1345, 'MILKSHAKE', 70, 2
UNION ALL SELECT 1346, 'SUNDAE', 71, 3
UNION ALL SELECT 1347, '375ML CAN', 72, 2
UNION ALL SELECT 1348, 'BOTTLE WATER', 73, 2
UNION ALL SELECT 1349, 'LO-CAL ICED COFF', 74, 2
UNION ALL SELECT 1350, 'ICED FRUIT TEA', 75, 2
UNION ALL SELECT 1351, 'MOCHA YOGHURT', 76, 2
UNION ALL SELECT 1352, 'FRESH P/APPLE JC', 77, 2
UNION ALL SELECT 1353, 'FROZ. CAPP', 78, 2
UNION ALL SELECT 1354, 'CAFE SPECIALE', 8, 1
UNION ALL SELECT 1355, '500ML MIN WATER', 80, 2
UNION ALL SELECT 1356, '250ML MIN WATER', 81, 2
UNION ALL SELECT 1357, 'CHINOTTO', 82, 2
UNION ALL SELECT 1358, 'CHOC MILKSHAKE', 83, 2
UNION ALL SELECT 1359, 'VAN MILKSHAKE', 84, 2
UNION ALL SELECT 1360, 'CARAML MILKSHAKE', 85, 2
UNION ALL SELECT 1361, 'STRBRY MILKSHAKE', 86, 2
UNION ALL SELECT 1362, 'LIMONATA', 87, 2
UNION ALL SELECT 1363, 'COKE', 88, 2
UNION ALL SELECT 1364, 'DIET COKE', 89, 2
UNION ALL SELECT 1365, 'CAFE MOCHA', 9, 1
UNION ALL SELECT 1366, 'FANTA', 90, 2
UNION ALL SELECT 1367, 'GARDEN SALAD', 900, 9
UNION ALL SELECT 1368, 'CAESAR SALAD', 901, 9
UNION ALL SELECT 1369, 'TROPICAL CHICKEN', 902, 9
UNION ALL SELECT 1370, 'CHICKEN CAESAR', 903, 9
UNION ALL SELECT 1371, 'GREEK SALAD', 904, 9
UNION ALL SELECT 1372, 'GREEK SALAD-LRG', 905, 9
UNION ALL SELECT 1373, 'GARDEN SALAD-LRG', 906, 9
UNION ALL SELECT 1374, 'CAESAR SALAD-LRG', 907, 9
UNION ALL SELECT 1375, 'CHICK CAESAR-LRG', 908, 9
UNION ALL SELECT 1376, 'SALAD SMALL', 909, 9
UNION ALL SELECT 1377, 'SPRITE', 91, 2
UNION ALL SELECT 1378, 'SALAD LARGE', 910, 9
UNION ALL SELECT 1379, 'FRUIT PACK', 911, 9
UNION ALL SELECT 1380, 'FRUIT SALAD', 912, 9
UNION ALL SELECT 1381, 'LIFT', 92, 2
UNION ALL SELECT 1382, 'STRONG', 93, 1
UNION ALL SELECT 1383, 'WEAK', 94, 1
UNION ALL SELECT 1384, 'OTHER DRINK', 95, 2
UNION ALL SELECT 1385, 'PEPPERMINT TEA', 96, 1
UNION ALL SELECT 1386, 'CHAMOMILE', 97, 1
UNION ALL SELECT 1387, 'BLUE LAGOON', 98, 1
UNION ALL SELECT 1388, 'DARJEELING BLEND', 99, 1
INSERT INTO @View SELECT PkID, Name, GroupID FROM @Group UNION SELECT PkID, Name, GroupID FROM @product
DECLARE @Target int, @Level int
SELECT @Target = 23
INSERT INTO @Result SELECT PkID, Name, GroupID, CAST(PkID as VARBINARY(6000)), 0 FROM @View WHERE PkID = @Target
SELECT @Level = 1
INSERT INTO @Temp1 VALUES (@Target)
WHILE (SELECT COUNT(*) FROM @Temp1) > 0
BEGIN
INSERT INTO @Result SELECT A.PkID, A.Name, A.GroupID, B.Sequence + CAST(A.PkID as VARBINARY(6000)), @Level FROM @View A INNER JOIN @Result B ON B.PkId = A.GroupID WHERE A.GroupID IN (SELECT A FROM @Temp1)
DELETE FROM @Temp2
INSERT INTO @Temp2 SELECT A FROM @Temp1
DELETE FROM @Temp1
INSERT INTO @Temp1 SELECT PkID FROM @View WHERE GroupID IN (SELECT A FROM @Temp2)
SELECT @Level = @Level + 1
END
SELECT Level, PkID, Name FROM @Result ORDER BY Sequence
Regards,
K. Matsumura
May 14, 2007 at 8:48 pm
Thanks for the reply. But my goal is.......
When the user selects Drinks, it should display the data in the following way.
0 DRINKS BEVERAGES
2 HOT DRINKS
7 TEA
7 COFFEE
7 CAPPUCCINO
2 COLD DRINKS
8 COKE
8 JUICE
8 MILK
2 ALCOHOL
9 BEER
9 WINE
Hope you got it.
Thanks in advance.
May 14, 2007 at 9:00 pm
Change
SELECT Level, PkID, Name FROM @Result ORDER BY Sequence
to
SELECT Level, GroupID, Name FROM @Result ORDER BY Sequence
K. Matsumura
Viewing 13 posts - 16 through 27 (of 27 total)
You must be logged in to reply to this topic. Login to reply