Select Average By DATEPART Weekday

• spike62

  Say Hey Kid

  Points: 706

  More actions

  May 28, 2010 at 9:00 pm

  #235717

  Hi,

  I'm looking to select each day of the week from a date range and average the total of the results for each day. I've gotten as far as one day and one product, but am stuck on getting the rest. I am using SQLServer 2008:

  CREATE TABLE [dbo].[SalesQty](

  [SaleID] [int] IDENTITY(1,1) NOT NULL,

  [Date] [date] NOT NULL,

  [Description] [nvarchar](50) NOT NULL,

  [Qty] [int] NOT NULL,

  CONSTRAINT [PK_SalesQty] PRIMARY KEY CLUSTERED

  (

  [SaleID] ASC

  )

  --Sample Data

  2009-06-01Ribeye13

  2009-06-02Ribeye3

  2009-06-03Ribeye10

  2009-06-08Ribeye6

  2009-06-09Ribeye3

  2009-06-10Ribeye5

  2009-06-15Ribeye1

  2009-06-16Ribeye4

  2009-06-17Ribeye5

  2009-06-22Ribeye5

  2009-06-23Ribeye1

  2009-06-24Ribeye8

  2009-06-29Ribeye4

  2009-06-30Ribeye1

  Select Description, AVG(Qty) AS Monday

  FROM SalesQty

  WHERE Date BETWEEN '20090601' AND '20090630'

  AND (( @@datefirst + datepart(weekday, Date) -2 ) %7 + 1 ) = 1

  AND Description = 'Ribeye'

  GROUP BY Description

  How do I include the other six days? Results to be as such:

  Monday Tuesday Wednesday ...

  4 5 7 ...

  This will be called from a Windows Form App, displayed in a DataGridView. I will also be needing to do this for a variable number of products.

  Any and all suggestions appreciated.

  Mike

• spike62

  Say Hey Kid

  Points: 706

  More actions

  May 29, 2010 at 4:15 am

  #1174220

  Hi again,

  I've managed to retrieve the info for the one day for the multiple items through joins to two other tables(I will supply CREATE TOs if neccessary after my follow up question below):

  SELECT ii.Description, AVG(sq.Qty) AS Monday

  FROM SalesQty sq

  LEFT JOIN InventoryItem_MenuItem im

  ON sq.MenuItem_ID = im.MenuItem_ID

  LEFT JOIN InventoryItem ii

  ON im.InvItem_ID = ii.InvItem_ID

  WHERE sq.Date BETWEEN '20090601' AND '20090630'

  AND (( @@datefirst + datepart(weekday, sq.Date) -2 ) %7 + 1 ) = 1

  AND ii.Active = 1

  GROUP BY ii.Description, ii.Level1_ID, ii.Level2_ID, ii.Level3_ID

  ORDER BY ii.Level1_ID, ii.Level2_ID, ii.Level3_ID

  Works fine for one day. I guess my question(s) boils down to this: Is there any way to nest such a query for all seven days of the week and create a single view? Or is there a better way to do this?

  This was the first solution I came across that my mind could grasp, I am willing to re-think the entire matter if anyone could set me on a different track.

  Thanks again,

  Mike

• Jeff Moden

  SSC Guru

  Points: 1004641

  More actions

  May 29, 2010 at 10:15 pm

  #1174287

  Hi Mike,

  Heh... yeah, I realize it's a holiday weekend but it's also been way more than 24 hours since you posted. Remember what I suggested on a previous post to you? If not then, as a reminder,take a look at the article at the first link in my signature below. 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• spike62

  Say Hey Kid

  Points: 706

  More actions

  May 30, 2010 at 4:58 am

  #1174316

  Sorry Jeff!:-)

  I guess I was impatient and looking for a quick push in the right direction. I've gotten most of the code together, but have to go to work right now. I will post all this evening. Please take the time to check back.

  Thanks,

  Mike

• Jeff Moden

  SSC Guru

  Points: 1004641

  More actions

  May 30, 2010 at 12:21 pm

  #1174350

  spike62 (5/30/2010)

  ---

  Sorry Jeff!:-)

  I guess I was impatient and looking for a quick push in the right direction. I've gotten most of the code together, but have to go to work right now. I will post all this evening. Please take the time to check back.

  Thanks,

  Mike

  Here's the "quick push"... use a Tally table to generate the missing dates and join to those dates.

  Heh... the problem is that most folks don't understand that type of quick push and that's why I recommend that folks take the bit of time to format their data in a readily consumbable format. That's all the you really need to do in your original post.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• spike62

  Say Hey Kid

  Points: 706

  More actions

  May 30, 2010 at 3:58 pm

  #1174364

  Hi again all!

  Jeff: Did you teach me a Tally Table in that same post 2 years ago? Sounds familiar, I'll have to look back at that! In the mean time, I'm going ahead and posting all, and if you still think that is the solution, then please re-enlighten me.

  This application is for a daily restaurant inventory, "Hot" items that we count every day in order to set pars to pull, marinate, etc., and to keep everyone honest.

  The first table, "InventoryItem", contains the items we acually count.

  --===== If the test table already exists, drop it

  IF OBJECT_ID('TempDB..InventoryItem','U') IS NOT NULL

  DROP TABLE InventoryItem

  --===== Create the test table with

  CREATE TABLE [dbo].[InventoryItem](

  [InvItem_ID] [int] IDENTITY(1,1) NOT NULL,

  [Description] [varchar](50) NOT NULL,

  [Level1_ID] [tinyint] NOT NULL,

  [Level2_ID] [tinyint] NOT NULL,

  [Level3_ID] [tinyint] NOT NULL,

  [Active] [bit] NOT NULL,

  [Portion] [bit] NOT NULL,

  [InvUnit] [int] NOT NULL,

  [Amount] [decimal](18, 5) NOT NULL,

  [BaseUnit] [int] NOT NULL,

  CONSTRAINT [PK_Item] PRIMARY KEY CLUSTERED

  (

  [InvItem_ID] ASC

  )

  --===== Setup any special required conditions especially where dates are concerned

  --===== All Inserts into the IDENTITY column

  SET IDENTITY_INSERT InventoryItem ON

  --===== Insert the test data into the test table

  INSERT INTO InventoryItem (InvItem_ID, Description, Level1_ID, Level2_ID, Level3_ID,

  Active, Portion, InvUnit, Amount, BaseUnit)

  SELECT '1','Ribeye','1','1','1','1','1','4','1.00000','9' UNION ALL

  SELECT '2','Filet','1','1','1','1','1','4','8.00000','9' UNION ALL

  SELECT '3','Tuna','1','3','5','1','0','4','5.92592','9' UNION ALL

  SELECT '4','Shrimp 16/20','1','3','6','1','0','8','16.00000','9' UNION ALL

  SELECT '5','Chicken 10 Oz.','1','2','4','1','0','4','10.00000','9' UNION ALL

  SELECT '6','Chicken 5 Oz.','1','2','4','1','0','4','5.00000','9' UNION ALL

  SELECT '7','Airline Chicken','1','2','4','1','0','4','12.00000','9' UNION ALL

  SELECT '8','Mahi 10 Oz.','1','3','5','1','0','4','10.00000','9' UNION ALL

  SELECT '9','Rack','1','1','2','1','0','4','1.00000','4' UNION ALL

  SELECT '10','Cod','1','3','5','1','1','4','10.00000','9' UNION ALL

  SELECT '11','Salmon','1','3','5','1','0','4','10.00000','9' UNION ALL

  SELECT '12','Calamari','1','3','6','1','0','4','10.00000','9' UNION ALL

  SELECT '13','Brisket','1','1','1','1','1','4','5.00000','9' UNION ALL

  SELECT '14','Pork Tenderloin','1','1','2','1','1','4','10.00000','9' UNION ALL

  SELECT '15','Country Rib','1','1','2','1','0','4','1.00000','8' UNION ALL

  SELECT '16','Bratwurst','1','1','3','1','0','4','0.33333','8' UNION ALL

  SELECT '17','Knockwurst','1','1','3','1','0','4','0.25000','8' UNION ALL

  SELECT '18','Weisswurst','1','1','3','1','0','4','0.20833','8' UNION ALL

  SELECT '19','Boiled Shrimp','1','3','6','1','0','8','16.00000','9' UNION ALL

  SELECT '20','P&D Shrimp','1','3','6','1','0','8','16.00000','9' UNION ALL

  SELECT '21','Prime Rib','1','1','1','1','1','8','16.00000','9' UNION ALL

  SELECT '22','Hot Beef Portion','1','1','1','1','1','4','4.00000','9'

  --===== Set the identity insert back to normal

  SET IDENTITY_INSERTInventoryItem OFF

  The next table, "MenuItem", contains all the products we sell that use the ingredients from "InventoryItem":

  --===== If the test table already exists, drop it

  IF OBJECT_ID('TempDB..MenuItem','U') IS NOT NULL

  DROP TABLE MenuItem

  --===== Create the test table with

  CREATE TABLE [dbo].[MenuItem](

  [MenuItem_ID] [int] IDENTITY(1,1) NOT NULL,

  [MenuCat_ID] [int] NULL,

  [POS] [int] NOT NULL,

  [Description] [varchar](255) NOT NULL,

  [Active] [bit] NULL,

  CONSTRAINT [PK_Recipe] PRIMARY KEY CLUSTERED

  (

  [MenuItem_ID] ASC

  )

  --===== Setup any special required conditions especially where dates are concerned

  --===== All Inserts into the IDENTITY column

  SET IDENTITY_INSERT MenuItem ON

  --===== Insert the test data into the test table

  INSERT INTO MenuItem (MenuItem_ID, MenuCat_ID, POS, Description, Active)

  SELECT '26','2','2713','Boiled Shrimp App','1' UNION ALL

  SELECT '29','2','3957','Shrimp Poppers','1' UNION ALL

  SELECT '35','2','3964','Calamari','1' UNION ALL

  SELECT '38','2','4231','1/2 Shrimp Poppers','1' UNION ALL

  SELECT '39','2','4232','1/2 Boiled Shrimp','1' UNION ALL

  SELECT '81','1','2036','Prime Rib 8oz.','1' UNION ALL

  SELECT '82','1','2037','Smoked Reg Prime','1' UNION ALL

  SELECT '83','1','2039','Ribeye','1' UNION ALL

  SELECT '84','1','2040','Smoked Brew Prime','1' UNION ALL

  SELECT '85','1','2041','Filet','1' UNION ALL

  SELECT '86','1','2044','Mahi-Mahi','1' UNION ALL

  SELECT '87','1','2046','Fried Chicken','1' UNION ALL

  SELECT '88','1','2048','Caribbean Chicken','1' UNION ALL

  SELECT '89','1','2049','Pork Medallions','1' UNION ALL

  SELECT '90','1','2053','Salmon Fillet','1' UNION ALL

  SELECT '104','8','4093','Smokehouse Combo/ Brewhouse','1' UNION ALL

  SELECT '105','8','4094','Smokehouse Combo/Caesar','1' UNION ALL

  SELECT '106','8','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '107','8','4096','Sausage Platter/ Caesar','1' UNION ALL

  SELECT '108','8','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '109','8','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '110','8','4099','Rack/ Salad','1' UNION ALL

  SELECT '111','8','4100','Rack/ Caesar','1' UNION ALL

  SELECT '112','8','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '113','8','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '114','8','4103','Shrimp & Salad','1' UNION ALL

  SELECT '115','8','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '116','8','4106','BBQ Chicken/ Brewhouse','1' UNION ALL

  SELECT '117','8','4107','BBQ Chicken/ Caesar','1' UNION ALL

  SELECT '118','8','4109','Country Style/Brewhouse','1' UNION ALL

  SELECT '119','8','4110','Country Style/Caesar','1' UNION ALL

  SELECT '122','8','4336','Fish & Chips/ Salad SUB','1' UNION ALL

  SELECT '123','8','4337','Fish & Chips/Caesar SUB','1' UNION ALL

  SELECT '124','8','4339','Shrimp & Chip/Caesar SUB','1' UNION ALL

  SELECT '125','8','4340','Shrimp & Chips/Salad SUB','1' UNION ALL

  SELECT '126','8','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '127','8','4343','Sausage Platter/Salad SUB','1' UNION ALL

  SELECT '128','8','4344','Sausage Platter/ Caesar SUB','1' UNION ALL

  SELECT '129','8','2047','Sausage Platter','1' UNION ALL

  SELECT '130','8','2052','Smokehouse Combo','1' UNION ALL

  SELECT '131','8','3498','Shrimp & Chips','1' UNION ALL

  SELECT '132','8','3501','Half Rack','1' UNION ALL

  SELECT '133','8','3507','Fish & Chips','1' UNION ALL

  SELECT '134','8','3934','Rack','1' UNION ALL

  SELECT '135','8','4105','BBQ Chicken Breast','1' UNION ALL

  SELECT '136','8','4108','Country Style Ribs','1' UNION ALL

  SELECT '137','8','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '138','8','4342','Sausage Platter SUB','1' UNION ALL

  SELECT '139','8','4366','Sub Sausage Platter Side','1' UNION ALL

  SELECT '143','11','2035','Kid Fish','1' UNION ALL

  SELECT '182','3','2025','Chicken Caesar Salad','1' UNION ALL

  SELECT '183','3','2027','Mill Salad/ Brisket','1' UNION ALL

  SELECT '185','3','2031','Mill Salad/ Chicken','1' UNION ALL

  SELECT '197','3','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '199','3','3972','Jamaican Salad','1' UNION ALL

  SELECT '200','3','3973','Greek Salad','1' UNION ALL

  SELECT '201','3','4263','Lg Brewhouse/Chicken','1' UNION ALL

  SELECT '202','3','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '209','3','4463','Mill Salad/Tuna','1' UNION ALL

  SELECT '210','3','4464','Mill Salad/Pork','1' UNION ALL

  SELECT '211','3','4466','Lg. Brewhouse/Brisket','1' UNION ALL

  SELECT '221','5','2086','BBQ Chx Sandwich','1' UNION ALL

  SELECT '223','5','2091','Tuna Sandwich','1' UNION ALL

  SELECT '224','5','2094','Caribbean Chix Sand','1' UNION ALL

  SELECT '226','5','2097','Hot Beef Sand','1' UNION ALL

  SELECT '227','5','2098','Brat Sand','1' UNION ALL

  SELECT '230','5','2884','Fish Sandwich','1' UNION ALL

  SELECT '236','5','3468','Grilled Prime Sandwich','1' UNION ALL

  SELECT '237','5','3469','Pork Sandwich','1' UNION ALL

  SELECT '239','5','3549','Plain Chx Sand','1' UNION ALL

  SELECT '242','5','3732','Brisket Sandwich','1' UNION ALL

  SELECT '286','24','2766','Prime Special 10 oz.','1' UNION ALL

  SELECT '287','24','4090','Prime Special 8 oz.','1' UNION ALL

  SELECT '383','14','2398','Boiled Shrimp','1' UNION ALL

  SELECT '385','14','2416','Shrimp','1' UNION ALL

  SELECT '386','14','2417','Chicken','1' UNION ALL

  SELECT '395','14','2565','+ Chicken 5 oz 4.25','1' UNION ALL

  SELECT '405','14','2583','+ Prime 1.00','1' UNION ALL

  SELECT '408','14','2593','3 Shrimp Boiled','1' UNION ALL

  SELECT '410','14','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '456','14','3372','+ 3 Shrimp','1' UNION ALL

  SELECT '463','14','3423','+ Sub Mahi $2.00','1' UNION ALL

  SELECT '501','14','3590','2 Boiled Shrimp','1' UNION ALL

  SELECT '508','14','3632','+ 3 Shrimp 3.99','1' UNION ALL

  SELECT '541','14','4029','+ Brat','1' UNION ALL

  SELECT '555','14','4043','+ Knockwurst','1' UNION ALL

  SELECT '575','14','4063','+ Smoked Brisket','1' UNION ALL

  SELECT '584','14','4072','+ Weisswurst','1' UNION ALL

  SELECT '588','14','4076','+ Rib Oz.','1' UNION ALL

  SELECT '589','14','4077','+ 2 Shrimp','1' UNION ALL

  SELECT '590','14','4079','+ Brisket 1.25','1' UNION ALL

  SELECT '1421','17','4662','Red Bull','1'

  --===== Set the identity insert back to normal

  SET IDENTITY_INSERT MenuItem OFF

  The third table "InventoryItem_MenuItem" is a "Helper" table to handle the Many-To-Many relationships:

  --===== If the test table already exists, drop it

  IF OBJECT_ID('TempDB..InventoryItem_MenuItem','U') IS NOT NULL

  DROP TABLE InventoryItem_MenuItem

  --===== Create the test table with

  CREATE TABLE [dbo].[InventoryItem_MenuItem](

  [Ingredient_ID] [int] IDENTITY(1,1) NOT NULL,

  [InvItem_ID] [int] NOT NULL,

  [MenuItem_ID] [int] NOT NULL,

  [Amount] [numeric](18, 2) NOT NULL,

  [UOM] [int] NOT NULL,

  CONSTRAINT [PK_InventoryItem_MenuItem] PRIMARY KEY CLUSTERED

  (

  [Ingredient_ID] ASC

  )

  --===== Setup any special required conditions especially where dates are concerned

  --===== All Inserts into the IDENTITY column

  SET IDENTITY_INSERT InventoryItem_MenuItem ON

  --===== Insert the test data into the test table

  INSERT INTO InventoryItem_MenuItem (Ingredient_ID, InvItem_ID, MenuItem_ID, Amount, UOM)

  SELECT '2','1','83','1.00','4' UNION ALL

  SELECT '3','2','85','1.00','4' UNION ALL

  SELECT '4','5','88','1.00','4' UNION ALL

  SELECT '5','8','86','1.00','4' UNION ALL

  SELECT '6','14','89','1.00','4' UNION ALL

  SELECT '7','11','90','1.00','4' UNION ALL

  SELECT '8','19','39','0.17','8' UNION ALL

  SELECT '9','20','38','0.11','8' UNION ALL

  SELECT '10','19','26','0.33','8' UNION ALL

  SELECT '11','12','35','1.00','4' UNION ALL

  SELECT '12','20','29','0.33','8' UNION ALL

  SELECT '13','6','182','1.00','4' UNION ALL

  SELECT '14','6','201','1.00','4' UNION ALL

  SELECT '15','3','202','1.00','4' UNION ALL

  SELECT '16','13','211','1.00','4' UNION ALL

  SELECT '17','13','183','1.00','4' UNION ALL

  SELECT '18','6','185','1.00','4' UNION ALL

  SELECT '19','14','210','0.50','4' UNION ALL

  SELECT '20','3','209','1.00','4' UNION ALL

  SELECT '21','3','197','1.00','4' UNION ALL

  SELECT '22','6','221','1.00','4' UNION ALL

  SELECT '23','16','227','1.00','4' UNION ALL

  SELECT '24','13','242','1.00','4' UNION ALL

  SELECT '25','6','224','1.00','4' UNION ALL

  SELECT '26','10','230','0.50','4' UNION ALL

  SELECT '28','6','239','1.00','4' UNION ALL

  SELECT '29','14','237','0.50','4' UNION ALL

  SELECT '30','3','223','1.00','4' UNION ALL

  SELECT '31','6','135','1.00','4' UNION ALL

  SELECT '32','7','116','1.00','4' UNION ALL

  SELECT '33','7','117','1.00','4' UNION ALL

  SELECT '34','15','136','1.00','4' UNION ALL

  SELECT '35','15','118','1.00','4' UNION ALL

  SELECT '36','15','119','1.00','4' UNION ALL

  SELECT '37','10','133','1.00','4' UNION ALL

  SELECT '38','10','113','1.00','4' UNION ALL

  SELECT '39','10','122','1.00','4' UNION ALL

  SELECT '40','10','137','1.00','4' UNION ALL

  SELECT '41','10','123','1.00','4' UNION ALL

  SELECT '42','10','112','1.00','4' UNION ALL

  SELECT '43','9','132','0.50','4' UNION ALL

  SELECT '44','9','109','0.50','4' UNION ALL

  SELECT '45','9','108','0.50','4' UNION ALL

  SELECT '46','9','134','1.00','4' UNION ALL

  SELECT '47','9','111','1.00','4' UNION ALL

  SELECT '48','9','110','1.00','4' UNION ALL

  SELECT '49','16','129','1.00','4' UNION ALL

  SELECT '50','17','129','1.00','4' UNION ALL

  SELECT '51','18','129','1.00','4' UNION ALL

  SELECT '52','16','138','1.00','4' UNION ALL

  SELECT '53','17','138','1.00','4' UNION ALL

  SELECT '54','18','138','1.00','4' UNION ALL

  SELECT '55','16','106','1.00','4' UNION ALL

  SELECT '56','17','106','1.00','4' UNION ALL

  SELECT '57','18','106','1.00','4' UNION ALL

  SELECT '58','16','107','1.00','4' UNION ALL

  SELECT '59','17','107','1.00','4' UNION ALL

  SELECT '60','18','107','1.00','4' UNION ALL

  SELECT '61','16','128','1.00','4' UNION ALL

  SELECT '62','17','128','1.00','4' UNION ALL

  SELECT '63','18','128','1.00','4' UNION ALL

  SELECT '64','20','115','0.33','8' UNION ALL

  SELECT '65','20','124','0.33','8' UNION ALL

  SELECT '66','20','131','0.33','8' UNION ALL

  SELECT '67','20','126','0.33','8' UNION ALL

  SELECT '68','20','125','0.33','8' UNION ALL

  SELECT '69','20','114','0.33','8' UNION ALL

  SELECT '70','9','130','0.50','4' UNION ALL

  SELECT '71','7','130','1.00','4' UNION ALL

  SELECT '72','9','104','0.50','4' UNION ALL

  SELECT '73','7','104','1.00','4' UNION ALL

  SELECT '74','9','105','0.50','4' UNION ALL

  SELECT '75','7','105','1.00','4' UNION ALL

  SELECT '76','10','143','0.50','4' UNION ALL

  SELECT '77','20','589','0.11','8' UNION ALL

  SELECT '78','20','456','0.17','8' UNION ALL

  SELECT '79','20','508','0.17','8' UNION ALL

  SELECT '80','16','541','1.00','4' UNION ALL

  SELECT '81','13','590','0.50','4' UNION ALL

  SELECT '82','6','410','1.00','4' UNION ALL

  SELECT '83','17','555','1.00','4' UNION ALL

  SELECT '84','13','575','0.50','4' UNION ALL

  SELECT '85','8','463','0.50','4' UNION ALL

  SELECT '86','18','584','1.00','4' UNION ALL

  SELECT '87','19','501','0.11','8' UNION ALL

  SELECT '88','19','408','0.17','8' UNION ALL

  SELECT '89','21','81','0.50','8' UNION ALL

  SELECT '90','21','82','0.75','8' UNION ALL

  SELECT '91','21','84','1.00','8' UNION ALL

  SELECT '92','22','226','1.00','4' UNION ALL

  SELECT '93','14','200','0.50','4' UNION ALL

  SELECT '94','21','236','0.38','8' UNION ALL

  SELECT '95','21','405','0.06','8'

  --===== Set the identity insert back to normal

  SET IDENTITY_INSERT InventoryItem OFF

  And finally, "SalesQty" which are the actual sale amounts of menu items on a daily basis (INSERT statement include the entire month of June 2009):

  --===== If the test table already exists, drop it

  IF OBJECT_ID('TempDB..SalesQty','U') IS NOT NULL

  DROP TABLE SalesQty

  --===== Create the test table with

  CREATE TABLE [dbo].[SalesQty](

  [SaleID] [int] IDENTITY(1,1) NOT NULL,

  [Date] [date] NOT NULL,

  [MenuItem_ID] [int] NULL,

  [POS] [int] NULL,

  [Description] [nvarchar](50) NOT NULL,

  [Qty] [int] NOT NULL,

  CONSTRAINT [PK_SalesQty] PRIMARY KEY CLUSTERED

  (

  [SaleID] ASC

  )

  --===== Setup any special required conditions especially where dates are concerned

  SET DATEFORMAT yyyyMMdd

  --===== All Inserts into the IDENTITY column

  SET IDENTITY_INSERT SalesQty ON

  --===== Insert the test data into the test table

  INSERT INTO SalesQty (SaleID, Date, MenuItem_ID, POS, Description, Qty)

  SELECT '16','2009-06-01','83','2039','Ribeye','13' UNION ALL

  SELECT '17','2009-06-01','90','2053','Salmon Fillet','12' UNION ALL

  SELECT '18','2009-06-01','82','2037','Smoked Reg Prime','11' UNION ALL

  SELECT '19','2009-06-01','85','2041','Filet','9' UNION ALL

  SELECT '20','2009-06-01','88','2048','Caribbean Chicken','8' UNION ALL

  SELECT '21','2009-06-01','89','2049','Pork Medallions','8' UNION ALL

  SELECT '23','2009-06-01','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '24','2009-06-01','81','2036','Prime Rib 8oz.','2' UNION ALL

  SELECT '25','2009-06-01','116','4106','BBQ Chicken/ Brewhouse','2' UNION ALL

  SELECT '26','2009-06-01','113','4102','Fish & Chips/ Caesar','2' UNION ALL

  SELECT '29','2009-06-01','126','4341','Shrimp & Chips SUB','2' UNION ALL

  SELECT '31','2009-06-01','110','4099','Rack/ Salad','1' UNION ALL

  SELECT '32','2009-06-01','109','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '33','2009-06-01','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '34','2009-06-01','117','4107','BBQ Chicken/ Caesar','1' UNION ALL

  SELECT '35','2009-06-01','112','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '42','2009-06-01','242','3732','Brisket Sandwich','18' UNION ALL

  SELECT '43','2009-06-01','236','3468','Grilled Prime Sandwich','13' UNION ALL

  SELECT '44','2009-06-01','224','2094','Caribbean Chix Sand','16' UNION ALL

  SELECT '45','2009-06-01','221','2086','BBQ Chx Sandwich','12' UNION ALL

  SELECT '46','2009-06-01','226','2097','Hot Beef Sand','9' UNION ALL

  SELECT '47','2009-06-01','223','2091','Tuna Sandwich','9' UNION ALL

  SELECT '48','2009-06-01','237','3469','Pork Sandwich','9' UNION ALL

  SELECT '49','2009-06-01','230','2884','Fish Sandwich','7' UNION ALL

  SELECT '51','2009-06-01','227','2098','Brat Sand','6' UNION ALL

  SELECT '58','2009-06-01','35','3964','Calamari','15' UNION ALL

  SELECT '61','2009-06-01','26','2713','Boiled Shrimp App','11' UNION ALL

  SELECT '64','2009-06-01','29','3957','Shrimp Poppers','9' UNION ALL

  SELECT '74','2009-06-01','132','3501','Half Rack','7' UNION ALL

  SELECT '75','2009-06-01','129','2047','Sausage Platter','6' UNION ALL

  SELECT '76','2009-06-01','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '77','2009-06-01','136','4108','Country Style Ribs','5' UNION ALL

  SELECT '78','2009-06-01','130','2052','Smokehouse Combo','3' UNION ALL

  SELECT '79','2009-06-01','133','3507','Fish & Chips','4' UNION ALL

  SELECT '80','2009-06-01','131','3498','Shrimp & Chips','3' UNION ALL

  SELECT '81','2009-06-01','134','3934','Rack','1' UNION ALL

  SELECT '84','2009-06-01','199','3972','Jamaican Salad','9' UNION ALL

  SELECT '85','2009-06-01','182','2025','Chicken Caesar Salad','6' UNION ALL

  SELECT '86','2009-06-01','200','3973','Greek Salad','4' UNION ALL

  SELECT '87','2009-06-01','201','4263','Lg Brewhouse/Chicken','4' UNION ALL

  SELECT '88','2009-06-01','185','2031','Mill Salad/ Chicken','3' UNION ALL

  SELECT '92','2009-06-01','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '93','2009-06-01','183','2027','Mill Salad/ Brisket','1' UNION ALL

  SELECT '106','2009-06-01','1421','4662','Red Bull','7' UNION ALL

  SELECT '191','2009-06-01','410','2596','+ Chick Breast $2.99','2' UNION ALL

  SELECT '239','2009-06-01','143','2035','Kid Fish','2' UNION ALL

  SELECT '364','2009-06-02','224','2094','Caribbean Chix Sand','27' UNION ALL

  SELECT '365','2009-06-02','226','2097','Hot Beef Sand','22' UNION ALL

  SELECT '367','2009-06-02','230','2884','Fish Sandwich','16' UNION ALL

  SELECT '368','2009-06-02','242','3732','Brisket Sandwich','16' UNION ALL

  SELECT '372','2009-06-02','236','3468','Grilled Prime Sandwich','7' UNION ALL

  SELECT '373','2009-06-02','237','3469','Pork Sandwich','8' UNION ALL

  SELECT '374','2009-06-02','221','2086','BBQ Chx Sandwich','6' UNION ALL

  SELECT '375','2009-06-02','223','2091','Tuna Sandwich','5' UNION ALL

  SELECT '377','2009-06-02','227','2098','Brat Sand','3' UNION ALL

  SELECT '379','2009-06-02','89','2049','Pork Medallions','8' UNION ALL

  SELECT '380','2009-06-02','86','2044','Mahi-Mahi','6' UNION ALL

  SELECT '381','2009-06-02','82','2037','Smoked Reg Prime','5' UNION ALL

  SELECT '382','2009-06-02','81','2036','Prime Rib 8oz.','5' UNION ALL

  SELECT '383','2009-06-02','83','2039','Ribeye','3' UNION ALL

  SELECT '384','2009-06-02','90','2053','Salmon Fillet','3' UNION ALL

  SELECT '386','2009-06-02','88','2048','Caribbean Chicken','3' UNION ALL

  SELECT '388','2009-06-02','84','2040','Smoked Brew Prime','1' UNION ALL

  SELECT '389','2009-06-02','85','2041','Filet','1' UNION ALL

  SELECT '391','2009-06-02','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '394','2009-06-02','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '395','2009-06-02','112','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '396','2009-06-02','119','4110','Country Style/Caesar','1' UNION ALL

  SELECT '397','2009-06-02','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '398','2009-06-02','107','4096','Sausage Platter/ Caesar','1' UNION ALL

  SELECT '404','2009-06-02','35','3964','Calamari','10' UNION ALL

  SELECT '411','2009-06-02','29','3957','Shrimp Poppers','5' UNION ALL

  SELECT '412','2009-06-02','26','2713','Boiled Shrimp App','3' UNION ALL

  SELECT '417','2009-06-02','133','3507','Fish & Chips','18' UNION ALL

  SELECT '418','2009-06-02','129','2047','Sausage Platter','14' UNION ALL

  SELECT '419','2009-06-02','131','3498','Shrimp & Chips','5' UNION ALL

  SELECT '420','2009-06-02','135','4105','BBQ Chicken Breast','4' UNION ALL

  SELECT '421','2009-06-02','136','4108','Country Style Ribs','4' UNION ALL

  SELECT '422','2009-06-02','134','3934','Rack','2' UNION ALL

  SELECT '423','2009-06-02','132','3501','Half Rack','2' UNION ALL

  SELECT '424','2009-06-02','130','2052','Smokehouse Combo','1' UNION ALL

  SELECT '425','2009-06-02','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '427','2009-06-02','200','3973','Greek Salad','16' UNION ALL

  SELECT '428','2009-06-02','185','2031','Mill Salad/ Chicken','9' UNION ALL

  SELECT '429','2009-06-02','199','3972','Jamaican Salad','8' UNION ALL

  SELECT '431','2009-06-02','201','4263','Lg Brewhouse/Chicken','6' UNION ALL

  SELECT '432','2009-06-02','183','2027','Mill Salad/ Brisket','4' UNION ALL

  SELECT '433','2009-06-02','182','2025','Chicken Caesar Salad','4' UNION ALL

  SELECT '435','2009-06-02','202','4264','Lg Brewhouse/Tuna','2' UNION ALL

  SELECT '436','2009-06-02','197','3631','Tuna Caesar Salad','2' UNION ALL

  SELECT '446','2009-06-02','1421','4662','Red Bull','3' UNION ALL

  SELECT '527','2009-06-02','410','2596','+ Chick Breast $2.99','2' UNION ALL

  SELECT '712','2009-06-03','242','3732','Brisket Sandwich','21' UNION ALL

  SELECT '714','2009-06-03','236','3468','Grilled Prime Sandwich','14' UNION ALL

  SELECT '715','2009-06-03','224','2094','Caribbean Chix Sand','16' UNION ALL

  SELECT '716','2009-06-03','230','2884','Fish Sandwich','13' UNION ALL

  SELECT '717','2009-06-03','226','2097','Hot Beef Sand','13' UNION ALL

  SELECT '718','2009-06-03','221','2086','BBQ Chx Sandwich','13' UNION ALL

  SELECT '719','2009-06-03','223','2091','Tuna Sandwich','7' UNION ALL

  SELECT '720','2009-06-03','237','3469','Pork Sandwich','7' UNION ALL

  SELECT '725','2009-06-03','227','2098','Brat Sand','2' UNION ALL

  SELECT '727','2009-06-03','82','2037','Smoked Reg Prime','13' UNION ALL

  SELECT '728','2009-06-03','90','2053','Salmon Fillet','12' UNION ALL

  SELECT '729','2009-06-03','83','2039','Ribeye','10' UNION ALL

  SELECT '730','2009-06-03','89','2049','Pork Medallions','8' UNION ALL

  SELECT '731','2009-06-03','86','2044','Mahi-Mahi','5' UNION ALL

  SELECT '732','2009-06-03','84','2040','Smoked Brew Prime','4' UNION ALL

  SELECT '733','2009-06-03','88','2048','Caribbean Chicken','5' UNION ALL

  SELECT '734','2009-06-03','115','4104','Shrimp & Caesar','2' UNION ALL

  SELECT '737','2009-06-03','85','2041','Filet','1' UNION ALL

  SELECT '738','2009-06-03','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '739','2009-06-03','81','2036','Prime Rib 8oz.','1' UNION ALL

  SELECT '740','2009-06-03','114','4103','Shrimp & Salad','1' UNION ALL

  SELECT '741','2009-06-03','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '756','2009-06-03','35','3964','Calamari','17' UNION ALL

  SELECT '760','2009-06-03','26','2713','Boiled Shrimp App','9' UNION ALL

  SELECT '764','2009-06-03','29','3957','Shrimp Poppers','4' UNION ALL

  SELECT '770','2009-06-03','133','3507','Fish & Chips','17' UNION ALL

  SELECT '771','2009-06-03','130','2052','Smokehouse Combo','8' UNION ALL

  SELECT '772','2009-06-03','129','2047','Sausage Platter','9' UNION ALL

  SELECT '773','2009-06-03','132','3501','Half Rack','8' UNION ALL

  SELECT '774','2009-06-03','131','3498','Shrimp & Chips','7' UNION ALL

  SELECT '775','2009-06-03','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '776','2009-06-03','137','4335','Fish & Chips/ SUB','2' UNION ALL

  SELECT '777','2009-06-03','134','3934','Rack','1' UNION ALL

  SELECT '778','2009-06-03','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '824','2009-06-03','200','3973','Greek Salad','8' UNION ALL

  SELECT '826','2009-06-03','199','3972','Jamaican Salad','6' UNION ALL

  SELECT '827','2009-06-03','185','2031','Mill Salad/ Chicken','5' UNION ALL

  SELECT '828','2009-06-03','183','2027','Mill Salad/ Brisket','3' UNION ALL

  SELECT '831','2009-06-03','201','4263','Lg Brewhouse/Chicken','1' UNION ALL

  SELECT '839','2009-06-03','1421','4662','Red Bull','4' UNION ALL

  SELECT '1051','2009-06-04','236','3468','Grilled Prime Sandwich','19' UNION ALL

  SELECT '1053','2009-06-04','226','2097','Hot Beef Sand','17' UNION ALL

  SELECT '1054','2009-06-04','230','2884','Fish Sandwich','14' UNION ALL

  SELECT '1055','2009-06-04','224','2094','Caribbean Chix Sand','15' UNION ALL

  SELECT '1056','2009-06-04','242','3732','Brisket Sandwich','14' UNION ALL

  SELECT '1057','2009-06-04','237','3469','Pork Sandwich','13' UNION ALL

  SELECT '1059','2009-06-04','223','2091','Tuna Sandwich','8' UNION ALL

  SELECT '1061','2009-06-04','227','2098','Brat Sand','7' UNION ALL

  SELECT '1064','2009-06-04','221','2086','BBQ Chx Sandwich','3' UNION ALL

  SELECT '1075','2009-06-04','35','3964','Calamari','15' UNION ALL

  SELECT '1077','2009-06-04','29','3957','Shrimp Poppers','9' UNION ALL

  SELECT '1078','2009-06-04','26','2713','Boiled Shrimp App','7' UNION ALL

  SELECT '1086','2009-06-04','88','2048','Caribbean Chicken','14' UNION ALL

  SELECT '1087','2009-06-04','90','2053','Salmon Fillet','10' UNION ALL

  SELECT '1089','2009-06-04','83','2039','Ribeye','4' UNION ALL

  SELECT '1090','2009-06-04','89','2049','Pork Medallions','4' UNION ALL

  SELECT '1092','2009-06-04','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '1094','2009-06-04','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '1097','2009-06-04','111','4100','Rack/ Caesar','1' UNION ALL

  SELECT '1098','2009-06-04','85','2041','Filet','1' UNION ALL

  SELECT '1099','2009-06-04','82','2037','Smoked Reg Prime','1' UNION ALL

  SELECT '1100','2009-06-04','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '1101','2009-06-04','81','2036','Prime Rib 8oz.','1' UNION ALL

  SELECT '1102','2009-06-04','114','4103','Shrimp & Salad','1' UNION ALL

  SELECT '1103','2009-06-04','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '1108','2009-06-04','133','3507','Fish & Chips','17' UNION ALL

  SELECT '1109','2009-06-04','132','3501','Half Rack','11' UNION ALL

  SELECT '1110','2009-06-04','131','3498','Shrimp & Chips','10' UNION ALL

  SELECT '1111','2009-06-04','134','3934','Rack','5' UNION ALL

  SELECT '1112','2009-06-04','135','4105','BBQ Chicken Breast','7' UNION ALL

  SELECT '1113','2009-06-04','130','2052','Smokehouse Combo','5' UNION ALL

  SELECT '1114','2009-06-04','129','2047','Sausage Platter','6' UNION ALL

  SELECT '1115','2009-06-04','136','4108','Country Style Ribs','3' UNION ALL

  SELECT '1116','2009-06-04','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '1170','2009-06-04','1421','4662','Red Bull','9' UNION ALL

  SELECT '1182','2009-06-04','200','3973','Greek Salad','8' UNION ALL

  SELECT '1183','2009-06-04','199','3972','Jamaican Salad','7' UNION ALL

  SELECT '1184','2009-06-04','185','2031','Mill Salad/ Chicken','6' UNION ALL

  SELECT '1185','2009-06-04','201','4263','Lg Brewhouse/Chicken','7' UNION ALL

  SELECT '1187','2009-06-04','183','2027','Mill Salad/ Brisket','5' UNION ALL

  SELECT '1189','2009-06-04','182','2025','Chicken Caesar Salad','2' UNION ALL

  SELECT '1190','2009-06-04','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '1234','2009-06-04','143','2035','Kid Fish','5' UNION ALL

  SELECT '1255','2009-06-04','590','4079','+ Brisket 1.25','1' UNION ALL

  SELECT '1421','2009-06-05','236','3468','Grilled Prime Sandwich','26' UNION ALL

  SELECT '1423','2009-06-05','224','2094','Caribbean Chix Sand','26' UNION ALL

  SELECT '1424','2009-06-05','242','3732','Brisket Sandwich','25' UNION ALL

  SELECT '1425','2009-06-05','226','2097','Hot Beef Sand','23' UNION ALL

  SELECT '1426','2009-06-05','230','2884','Fish Sandwich','16' UNION ALL

  SELECT '1427','2009-06-05','237','3469','Pork Sandwich','17' UNION ALL

  SELECT '1428','2009-06-05','223','2091','Tuna Sandwich','15' UNION ALL

  SELECT '1432','2009-06-05','221','2086','BBQ Chx Sandwich','10' UNION ALL

  SELECT '1434','2009-06-05','227','2098','Brat Sand','3' UNION ALL

  SELECT '1443','2009-06-05','35','3964','Calamari','18' UNION ALL

  SELECT '1444','2009-06-05','26','2713','Boiled Shrimp App','20' UNION ALL

  SELECT '1450','2009-06-05','29','3957','Shrimp Poppers','6' UNION ALL

  SELECT '1517','2009-06-05','82','2037','Smoked Reg Prime','9' UNION ALL

  SELECT '1518','2009-06-05','86','2044','Mahi-Mahi','7' UNION ALL

  SELECT '1519','2009-06-05','112','4101','Fish & Chips/Salad','7' UNION ALL

  SELECT '1520','2009-06-05','83','2039','Ribeye','6' UNION ALL

  SELECT '1521','2009-06-05','90','2053','Salmon Fillet','5' UNION ALL

  SELECT '1522','2009-06-05','88','2048','Caribbean Chicken','4' UNION ALL

  SELECT '1523','2009-06-05','85','2041','Filet','3' UNION ALL

  SELECT '1524','2009-06-05','89','2049','Pork Medallions','4' UNION ALL

  SELECT '1525','2009-06-05','81','2036','Prime Rib 8oz.','3' UNION ALL

  SELECT '1526','2009-06-05','84','2040','Smoked Brew Prime','2' UNION ALL

  SELECT '1527','2009-06-05','126','4341','Shrimp & Chips SUB','3' UNION ALL

  SELECT '1529','2009-06-05','113','4102','Fish & Chips/ Caesar','2' UNION ALL

  SELECT '1533','2009-06-05','109','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '1534','2009-06-05','115','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '1535','2009-06-05','125','4340','Shrimp & Chips/Salad SUB','1' UNION ALL

  SELECT '1536','2009-06-05','114','4103','Shrimp & Salad','1' UNION ALL

  SELECT '1537','2009-06-05','107','4096','Sausage Platter/ Caesar','1' UNION ALL

  SELECT '1542','2009-06-05','133','3507','Fish & Chips','31' UNION ALL

  SELECT '1543','2009-06-05','131','3498','Shrimp & Chips','18' UNION ALL

  SELECT '1544','2009-06-05','130','2052','Smokehouse Combo','5' UNION ALL

  SELECT '1545','2009-06-05','129','2047','Sausage Platter','6' UNION ALL

  SELECT '1546','2009-06-05','132','3501','Half Rack','5' UNION ALL

  SELECT '1547','2009-06-05','136','4108','Country Style Ribs','5' UNION ALL

  SELECT '1548','2009-06-05','134','3934','Rack','3' UNION ALL

  SELECT '1549','2009-06-05','135','4105','BBQ Chicken Breast','4' UNION ALL

  SELECT '1567','2009-06-05','199','3972','Jamaican Salad','15' UNION ALL

  SELECT '1569','2009-06-05','200','3973','Greek Salad','11' UNION ALL

  SELECT '1570','2009-06-05','182','2025','Chicken Caesar Salad','9' UNION ALL

  SELECT '1571','2009-06-05','185','2031','Mill Salad/ Chicken','6' UNION ALL

  SELECT '1572','2009-06-05','201','4263','Lg Brewhouse/Chicken','3' UNION ALL

  SELECT '1574','2009-06-05','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '1576','2009-06-05','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '1589','2009-06-05','1421','4662','Red Bull','16' UNION ALL

  SELECT '1631','2009-06-05','143','2035','Kid Fish','5' UNION ALL

  SELECT '1656','2009-06-05','590','4079','+ Brisket 1.25','1' UNION ALL

  SELECT '1846','2009-06-06','236','3468','Grilled Prime Sandwich','41' UNION ALL

  SELECT '1847','2009-06-06','224','2094','Caribbean Chix Sand','48' UNION ALL

  SELECT '1848','2009-06-06','230','2884','Fish Sandwich','33' UNION ALL

  SELECT '1849','2009-06-06','226','2097','Hot Beef Sand','28' UNION ALL

  SELECT '1850','2009-06-06','223','2091','Tuna Sandwich','26' UNION ALL

  SELECT '1851','2009-06-06','221','2086','BBQ Chx Sandwich','27' UNION ALL

  SELECT '1852','2009-06-06','242','3732','Brisket Sandwich','26' UNION ALL

  SELECT '1856','2009-06-06','237','3469','Pork Sandwich','17' UNION ALL

  SELECT '1857','2009-06-06','227','2098','Brat Sand','11' UNION ALL

  SELECT '1884','2009-06-06','29','3957','Shrimp Poppers','10' UNION ALL

  SELECT '1885','2009-06-06','35','3964','Calamari','10' UNION ALL

  SELECT '1886','2009-06-06','26','2713','Boiled Shrimp App','8' UNION ALL

  SELECT '1891','2009-06-06','90','2053','Salmon Fillet','9' UNION ALL

  SELECT '1892','2009-06-06','82','2037','Smoked Reg Prime','8' UNION ALL

  SELECT '1893','2009-06-06','85','2041','Filet','7' UNION ALL

  SELECT '1894','2009-06-06','81','2036','Prime Rib 8oz.','8' UNION ALL

  SELECT '1895','2009-06-06','89','2049','Pork Medallions','9' UNION ALL

  SELECT '1896','2009-06-06','84','2040','Smoked Brew Prime','6' UNION ALL

  SELECT '1897','2009-06-06','83','2039','Ribeye','5' UNION ALL

  SELECT '1898','2009-06-06','112','4101','Fish & Chips/Salad','5' UNION ALL

  SELECT '1900','2009-06-06','88','2048','Caribbean Chicken','4' UNION ALL

  SELECT '1901','2009-06-06','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '1902','2009-06-06','114','4103','Shrimp & Salad','2' UNION ALL

  SELECT '1905','2009-06-06','109','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '1906','2009-06-06','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '1907','2009-06-06','116','4106','BBQ Chicken/ Brewhouse','1' UNION ALL

  SELECT '1908','2009-06-06','115','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '1909','2009-06-06','124','4339','Shrimp & Chip/Caesar SUB','1' UNION ALL

  SELECT '1910','2009-06-06','119','4110','Country Style/Caesar','1' UNION ALL

  SELECT '1911','2009-06-06','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '1912','2009-06-06','127','4343','Sausage Platter/Salad SUB','1' UNION ALL

  SELECT '1918','2009-06-06','133','3507','Fish & Chips','42' UNION ALL

  SELECT '1919','2009-06-06','135','4105','BBQ Chicken Breast','10' UNION ALL

  SELECT '1920','2009-06-06','130','2052','Smokehouse Combo','7' UNION ALL

  SELECT '1921','2009-06-06','136','4108','Country Style Ribs','9' UNION ALL

  SELECT '1922','2009-06-06','129','2047','Sausage Platter','9' UNION ALL

  SELECT '1923','2009-06-06','131','3498','Shrimp & Chips','8' UNION ALL

  SELECT '1924','2009-06-06','132','3501','Half Rack','7' UNION ALL

  SELECT '1925','2009-06-06','134','3934','Rack','3' UNION ALL

  SELECT '1989','2009-06-06','200','3973','Greek Salad','18' UNION ALL

  SELECT '1990','2009-06-06','199','3972','Jamaican Salad','15' UNION ALL

  SELECT '1991','2009-06-06','185','2031','Mill Salad/ Chicken','10' UNION ALL

  SELECT '1992','2009-06-06','182','2025','Chicken Caesar Salad','11' UNION ALL

  SELECT '1993','2009-06-06','201','4263','Lg Brewhouse/Chicken','8' UNION ALL

  SELECT '1997','2009-06-06','183','2027','Mill Salad/ Brisket','3' UNION ALL

  SELECT '2000','2009-06-06','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '2001','2009-06-06','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '2010','2009-06-06','1421','4662','Red Bull','13' UNION ALL

  SELECT '2078','2009-06-06','143','2035','Kid Fish','4' UNION ALL

  SELECT '2084','2009-06-06','410','2596','+ Chick Breast $2.99','5' UNION ALL

  SELECT '2272','2009-06-07','236','3468','Grilled Prime Sandwich','27' UNION ALL

  SELECT '2273','2009-06-07','224','2094','Caribbean Chix Sand','22' UNION ALL

  SELECT '2274','2009-06-07','230','2884','Fish Sandwich','17' UNION ALL

  SELECT '2275','2009-06-07','242','3732','Brisket Sandwich','18' UNION ALL

  SELECT '2277','2009-06-07','226','2097','Hot Beef Sand','14' UNION ALL

  SELECT '2278','2009-06-07','221','2086','BBQ Chx Sandwich','15' UNION ALL

  SELECT '2281','2009-06-07','223','2091','Tuna Sandwich','9' UNION ALL

  SELECT '2282','2009-06-07','227','2098','Brat Sand','8' UNION ALL

  SELECT '2283','2009-06-07','237','3469','Pork Sandwich','7' UNION ALL

  SELECT '2303','2009-06-07','35','3964','Calamari','16' UNION ALL

  SELECT '2309','2009-06-07','29','3957','Shrimp Poppers','6' UNION ALL

  SELECT '2315','2009-06-07','26','2713','Boiled Shrimp App','3' UNION ALL

  SELECT '2317','2009-06-07','81','2036','Prime Rib 8oz.','8' UNION ALL

  SELECT '2318','2009-06-07','90','2053','Salmon Fillet','5' UNION ALL

  SELECT '2319','2009-06-07','88','2048','Caribbean Chicken','5' UNION ALL

  SELECT '2320','2009-06-07','83','2039','Ribeye','4' UNION ALL

  SELECT '2321','2009-06-07','86','2044','Mahi-Mahi','4' UNION ALL

  SELECT '2322','2009-06-07','89','2049','Pork Medallions','4' UNION ALL

  SELECT '2323','2009-06-07','82','2037','Smoked Reg Prime','3' UNION ALL

  SELECT '2327','2009-06-07','104','4093','Smokehouse Combo/ Brewhouse','1' UNION ALL

  SELECT '2328','2009-06-07','84','2040','Smoked Brew Prime','1' UNION ALL

  SELECT '2329','2009-06-07','116','4106','BBQ Chicken/ Brewhouse','1' UNION ALL

  SELECT '2330','2009-06-07','117','4107','BBQ Chicken/ Caesar','1' UNION ALL

  SELECT '2331','2009-06-07','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '2333','2009-06-07','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '2335','2009-06-07','133','3507','Fish & Chips','17' UNION ALL

  SELECT '2336','2009-06-07','132','3501','Half Rack','9' UNION ALL

  SELECT '2337','2009-06-07','134','3934','Rack','5' UNION ALL

  SELECT '2338','2009-06-07','135','4105','BBQ Chicken Breast','7' UNION ALL

  SELECT '2339','2009-06-07','129','2047','Sausage Platter','7' UNION ALL

  SELECT '2340','2009-06-07','131','3498','Shrimp & Chips','6' UNION ALL

  SELECT '2341','2009-06-07','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '2342','2009-06-07','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '2359','2009-06-07','1421','4662','Red Bull','1' UNION ALL

  SELECT '2368','2009-06-07','199','3972','Jamaican Salad','10' UNION ALL

  SELECT '2369','2009-06-07','200','3973','Greek Salad','7' UNION ALL

  SELECT '2370','2009-06-07','185','2031','Mill Salad/ Chicken','5' UNION ALL

  SELECT '2371','2009-06-07','183','2027','Mill Salad/ Brisket','3' UNION ALL

  SELECT '2374','2009-06-07','197','3631','Tuna Caesar Salad','2' UNION ALL

  SELECT '2376','2009-06-07','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '2377','2009-06-07','182','2025','Chicken Caesar Salad','1' UNION ALL

  SELECT '2378','2009-06-07','201','4263','Lg Brewhouse/Chicken','1' UNION ALL

  SELECT '2425','2009-06-07','143','2035','Kid Fish','6' UNION ALL

  SELECT '2609','2009-06-08','242','3732','Brisket Sandwich','20' UNION ALL

  SELECT '2611','2009-06-08','236','3468','Grilled Prime Sandwich','13' UNION ALL

  SELECT '2613','2009-06-08','230','2884','Fish Sandwich','11' UNION ALL

  SELECT '2614','2009-06-08','224','2094','Caribbean Chix Sand','12' UNION ALL

  SELECT '2615','2009-06-08','226','2097','Hot Beef Sand','10' UNION ALL

  SELECT '2617','2009-06-08','221','2086','BBQ Chx Sandwich','8' UNION ALL

  SELECT '2618','2009-06-08','223','2091','Tuna Sandwich','7' UNION ALL

  SELECT '2619','2009-06-08','237','3469','Pork Sandwich','6' UNION ALL

  SELECT '2621','2009-06-08','227','2098','Brat Sand','3' UNION ALL

  SELECT '2624','2009-06-08','82','2037','Smoked Reg Prime','10' UNION ALL

  SELECT '2625','2009-06-08','88','2048','Caribbean Chicken','10' UNION ALL

  SELECT '2626','2009-06-08','89','2049','Pork Medallions','9' UNION ALL

  SELECT '2627','2009-06-08','83','2039','Ribeye','6' UNION ALL

  SELECT '2628','2009-06-08','86','2044','Mahi-Mahi','6' UNION ALL

  SELECT '2629','2009-06-08','90','2053','Salmon Fillet','6' UNION ALL

  SELECT '2630','2009-06-08','81','2036','Prime Rib 8oz.','5' UNION ALL

  SELECT '2631','2009-06-08','85','2041','Filet','4' UNION ALL

  SELECT '2632','2009-06-08','116','4106','BBQ Chicken/ Brewhouse','2' UNION ALL

  SELECT '2633','2009-06-08','114','4103','Shrimp & Salad','2' UNION ALL

  SELECT '2634','2009-06-08','110','4099','Rack/ Salad','1' UNION ALL

  SELECT '2636','2009-06-08','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '2637','2009-06-08','112','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '2638','2009-06-08','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '2639','2009-06-08','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '2648','2009-06-08','35','3964','Calamari','10' UNION ALL

  SELECT '2649','2009-06-08','26','2713','Boiled Shrimp App','9' UNION ALL

  SELECT '2652','2009-06-08','29','3957','Shrimp Poppers','8' UNION ALL

  SELECT '2658','2009-06-08','133','3507','Fish & Chips','21' UNION ALL

  SELECT '2659','2009-06-08','132','3501','Half Rack','8' UNION ALL

  SELECT '2660','2009-06-08','135','4105','BBQ Chicken Breast','8' UNION ALL

  SELECT '2661','2009-06-08','136','4108','Country Style Ribs','6' UNION ALL

  SELECT '2662','2009-06-08','129','2047','Sausage Platter','5' UNION ALL

  SELECT '2663','2009-06-08','134','3934','Rack','2' UNION ALL

  SELECT '2664','2009-06-08','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '2665','2009-06-08','131','3498','Shrimp & Chips','2' UNION ALL

  SELECT '2666','2009-06-08','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '2668','2009-06-08','199','3972','Jamaican Salad','12' UNION ALL

  SELECT '2670','2009-06-08','183','2027','Mill Salad/ Brisket','7' UNION ALL

  SELECT '2671','2009-06-08','185','2031','Mill Salad/ Chicken','4' UNION ALL

  SELECT '2672','2009-06-08','200','3973','Greek Salad','4' UNION ALL

  SELECT '2673','2009-06-08','182','2025','Chicken Caesar Salad','3' UNION ALL

  SELECT '2677','2009-06-08','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '2678','2009-06-08','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '2680','2009-06-08','201','4263','Lg Brewhouse/Chicken','1' UNION ALL

  SELECT '2720','2009-06-08','1421','4662','Red Bull','6' UNION ALL

  SELECT '2754','2009-06-08','143','2035','Kid Fish','3' UNION ALL

  SELECT '2775','2009-06-08','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '2809','2009-06-08','575','4063','+ Smoked Brisket','1' UNION ALL

  SELECT '2938','2009-06-09','230','2884','Fish Sandwich','15' UNION ALL

  SELECT '2939','2009-06-09','224','2094','Caribbean Chix Sand','16' UNION ALL

  SELECT '2940','2009-06-09','226','2097','Hot Beef Sand','12' UNION ALL

  SELECT '2941','2009-06-09','242','3732','Brisket Sandwich','13' UNION ALL

  SELECT '2942','2009-06-09','236','3468','Grilled Prime Sandwich','10' UNION ALL

  SELECT '2943','2009-06-09','223','2091','Tuna Sandwich','11' UNION ALL

  SELECT '2944','2009-06-09','221','2086','BBQ Chx Sandwich','11' UNION ALL

  SELECT '2948','2009-06-09','237','3469','Pork Sandwich','6' UNION ALL

  SELECT '2951','2009-06-09','227','2098','Brat Sand','2' UNION ALL

  SELECT '2956','2009-06-09','26','2713','Boiled Shrimp App','14' UNION ALL

  SELECT '2961','2009-06-09','35','3964','Calamari','7' UNION ALL

  SELECT '2967','2009-06-09','29','3957','Shrimp Poppers','1' UNION ALL

  SELECT '2971','2009-06-09','85','2041','Filet','6' UNION ALL

  SELECT '2972','2009-06-09','88','2048','Caribbean Chicken','5' UNION ALL

  SELECT '2973','2009-06-09','90','2053','Salmon Fillet','4' UNION ALL

  SELECT '2975','2009-06-09','89','2049','Pork Medallions','4' UNION ALL

  SELECT '2976','2009-06-09','82','2037','Smoked Reg Prime','3' UNION ALL

  SELECT '2977','2009-06-09','83','2039','Ribeye','3' UNION ALL

  SELECT '2978','2009-06-09','84','2040','Smoked Brew Prime','2' UNION ALL

  SELECT '2979','2009-06-09','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '2980','2009-06-09','106','4095','Sausage Platter/ Brewhouse','2' UNION ALL

  SELECT '2981','2009-06-09','107','4096','Sausage Platter/ Caesar','2' UNION ALL

  SELECT '2983','2009-06-09','110','4099','Rack/ Salad','1' UNION ALL

  SELECT '2985','2009-06-09','104','4093','Smokehouse Combo/ Brewhouse','1' UNION ALL

  SELECT '2987','2009-06-09','81','2036','Prime Rib 8oz.','1' UNION ALL

  SELECT '2988','2009-06-09','114','4103','Shrimp & Salad','1' UNION ALL

  SELECT '2990','2009-06-09','133','3507','Fish & Chips','11' UNION ALL

  SELECT '2991','2009-06-09','130','2052','Smokehouse Combo','7' UNION ALL

  SELECT '2992','2009-06-09','129','2047','Sausage Platter','8' UNION ALL

  SELECT '2993','2009-06-09','131','3498','Shrimp & Chips','5' UNION ALL

  SELECT '2994','2009-06-09','132','3501','Half Rack','4' UNION ALL

  SELECT '2995','2009-06-09','135','4105','BBQ Chicken Breast','4' UNION ALL

  SELECT '2996','2009-06-09','136','4108','Country Style Ribs','4' UNION ALL

  SELECT '3037','2009-06-09','199','3972','Jamaican Salad','10' UNION ALL

  SELECT '3038','2009-06-09','200','3973','Greek Salad','10' UNION ALL

  SELECT '3039','2009-06-09','183','2027','Mill Salad/ Brisket','5' UNION ALL

  SELECT '3041','2009-06-09','185','2031','Mill Salad/ Chicken','3' UNION ALL

  SELECT '3042','2009-06-09','182','2025','Chicken Caesar Salad','3' UNION ALL

  SELECT '3043','2009-06-09','201','4263','Lg Brewhouse/Chicken','1' UNION ALL

  SELECT '3051','2009-06-09','1421','4662','Red Bull','12' UNION ALL

  SELECT '3286','2009-06-10','236','3468','Grilled Prime Sandwich','21' UNION ALL

  SELECT '3287','2009-06-10','224','2094','Caribbean Chix Sand','24' UNION ALL

  SELECT '3288','2009-06-10','242','3732','Brisket Sandwich','22' UNION ALL

  SELECT '3289','2009-06-10','230','2884','Fish Sandwich','20' UNION ALL

  SELECT '3290','2009-06-10','226','2097','Hot Beef Sand','18' UNION ALL

  SELECT '3292','2009-06-10','221','2086','BBQ Chx Sandwich','18' UNION ALL

  SELECT '3293','2009-06-10','237','3469','Pork Sandwich','15' UNION ALL

  SELECT '3297','2009-06-10','223','2091','Tuna Sandwich','12' UNION ALL

  SELECT '3298','2009-06-10','227','2098','Brat Sand','9' UNION ALL

  SELECT '3307','2009-06-10','29','3957','Shrimp Poppers','12' UNION ALL

  SELECT '3308','2009-06-10','26','2713','Boiled Shrimp App','13' UNION ALL

  SELECT '3309','2009-06-10','35','3964','Calamari','10' UNION ALL

  SELECT '3318','2009-06-10','90','2053','Salmon Fillet','11' UNION ALL

  SELECT '3319','2009-06-10','86','2044','Mahi-Mahi','7' UNION ALL

  SELECT '3320','2009-06-10','81','2036','Prime Rib 8oz.','7' UNION ALL

  SELECT '3321','2009-06-10','89','2049','Pork Medallions','8' UNION ALL

  SELECT '3322','2009-06-10','88','2048','Caribbean Chicken','6' UNION ALL

  SELECT '3323','2009-06-10','83','2039','Ribeye','5' UNION ALL

  SELECT '3324','2009-06-10','84','2040','Smoked Brew Prime','4' UNION ALL

  SELECT '3325','2009-06-10','82','2037','Smoked Reg Prime','4' UNION ALL

  SELECT '3326','2009-06-10','114','4103','Shrimp & Salad','4' UNION ALL

  SELECT '3327','2009-06-10','109','4098','Half Rack/ Caesar','2' UNION ALL

  SELECT '3328','2009-06-10','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '3333','2009-06-10','115','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '3334','2009-06-10','119','4110','Country Style/Caesar','1' UNION ALL

  SELECT '3335','2009-06-10','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '3336','2009-06-10','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '3341','2009-06-10','133','3507','Fish & Chips','15' UNION ALL

  SELECT '3342','2009-06-10','131','3498','Shrimp & Chips','12' UNION ALL

  SELECT '3343','2009-06-10','129','2047','Sausage Platter','10' UNION ALL

  SELECT '3344','2009-06-10','135','4105','BBQ Chicken Breast','9' UNION ALL

  SELECT '3345','2009-06-10','132','3501','Half Rack','8' UNION ALL

  SELECT '3346','2009-06-10','130','2052','Smokehouse Combo','3' UNION ALL

  SELECT '3347','2009-06-10','137','4335','Fish & Chips/ SUB','2' UNION ALL

  SELECT '3348','2009-06-10','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '3350','2009-06-10','199','3972','Jamaican Salad','12' UNION ALL

  SELECT '3351','2009-06-10','185','2031','Mill Salad/ Chicken','9' UNION ALL

  SELECT '3352','2009-06-10','200','3973','Greek Salad','11' UNION ALL

  SELECT '3354','2009-06-10','201','4263','Lg Brewhouse/Chicken','8' UNION ALL

  SELECT '3355','2009-06-10','182','2025','Chicken Caesar Salad','3' UNION ALL

  SELECT '3358','2009-06-10','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '3360','2009-06-10','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '3375','2009-06-10','1421','4662','Red Bull','14' UNION ALL

  SELECT '3470','2009-06-10','143','2035','Kid Fish','2' UNION ALL

  SELECT '3491','2009-06-10','410','2596','+ Chick Breast $2.99','3' UNION ALL

  SELECT '3658','2009-06-11','224','2094','Caribbean Chix Sand','25' UNION ALL

  SELECT '3659','2009-06-11','242','3732','Brisket Sandwich','23' UNION ALL

  SELECT '3660','2009-06-11','236','3468','Grilled Prime Sandwich','19' UNION ALL

  SELECT '3661','2009-06-11','237','3469','Pork Sandwich','16' UNION ALL

  SELECT '3663','2009-06-11','226','2097','Hot Beef Sand','12' UNION ALL

  SELECT '3664','2009-06-11','223','2091','Tuna Sandwich','11' UNION ALL

  SELECT '3666','2009-06-11','230','2884','Fish Sandwich','9' UNION ALL

  SELECT '3667','2009-06-11','221','2086','BBQ Chx Sandwich','10' UNION ALL

  SELECT '3671','2009-06-11','227','2098','Brat Sand','6' UNION ALL

  SELECT '3673','2009-06-11','83','2039','Ribeye','14' UNION ALL

  SELECT '3674','2009-06-11','88','2048','Caribbean Chicken','10' UNION ALL

  SELECT '3675','2009-06-11','82','2037','Smoked Reg Prime','8' UNION ALL

  SELECT '3676','2009-06-11','84','2040','Smoked Brew Prime','7' UNION ALL

  SELECT '3677','2009-06-11','90','2053','Salmon Fillet','8' UNION ALL

  SELECT '3678','2009-06-11','85','2041','Filet','7' UNION ALL

  SELECT '3679','2009-06-11','81','2036','Prime Rib 8oz.','5' UNION ALL

  SELECT '3680','2009-06-11','86','2044','Mahi-Mahi','4' UNION ALL

  SELECT '3681','2009-06-11','89','2049','Pork Medallions','3' UNION ALL

  SELECT '3684','2009-06-11','116','4106','BBQ Chicken/ Brewhouse','2' UNION ALL

  SELECT '3685','2009-06-11','113','4102','Fish & Chips/ Caesar','2' UNION ALL

  SELECT '3687','2009-06-11','112','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '3688','2009-06-11','118','4109','Country Style/Brewhouse','1' UNION ALL

  SELECT '3690','2009-06-11','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '3703','2009-06-11','35','3964','Calamari','14' UNION ALL

  SELECT '3704','2009-06-11','26','2713','Boiled Shrimp App','10' UNION ALL

  SELECT '3706','2009-06-11','29','3957','Shrimp Poppers','9' UNION ALL

  SELECT '3713','2009-06-11','133','3507','Fish & Chips','23' UNION ALL

  SELECT '3714','2009-06-11','135','4105','BBQ Chicken Breast','7' UNION ALL

  SELECT '3715','2009-06-11','130','2052','Smokehouse Combo','4' UNION ALL

  SELECT '3716','2009-06-11','132','3501','Half Rack','5' UNION ALL

  SELECT '3717','2009-06-11','131','3498','Shrimp & Chips','5' UNION ALL

  SELECT '3718','2009-06-11','136','4108','Country Style Ribs','5' UNION ALL

  SELECT '3719','2009-06-11','134','3934','Rack','2' UNION ALL

  SELECT '3720','2009-06-11','129','2047','Sausage Platter','3' UNION ALL

  SELECT '3721','2009-06-11','137','4335','Fish & Chips/ SUB','2' UNION ALL

  SELECT '3764','2009-06-11','200','3973','Greek Salad','9' UNION ALL

  SELECT '3765','2009-06-11','199','3972','Jamaican Salad','8' UNION ALL

  SELECT '3766','2009-06-11','185','2031','Mill Salad/ Chicken','7' UNION ALL

  SELECT '3767','2009-06-11','182','2025','Chicken Caesar Salad','8' UNION ALL

  SELECT '3769','2009-06-11','183','2027','Mill Salad/ Brisket','6' UNION ALL

  SELECT '3771','2009-06-11','197','3631','Tuna Caesar Salad','3' UNION ALL

  SELECT '3772','2009-06-11','201','4263','Lg Brewhouse/Chicken','2' UNION ALL

  SELECT '3774','2009-06-11','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '3788','2009-06-11','1421','4662','Red Bull','10' UNION ALL

  SELECT '3858','2009-06-11','143','2035','Kid Fish','5' UNION ALL

  SELECT '4038','2009-06-12','242','3732','Brisket Sandwich','35' UNION ALL

  SELECT '4040','2009-06-12','224','2094','Caribbean Chix Sand','31' UNION ALL

  SELECT '4041','2009-06-12','230','2884','Fish Sandwich','23' UNION ALL

  SELECT '4042','2009-06-12','236','3468','Grilled Prime Sandwich','20' UNION ALL

  SELECT '4043','2009-06-12','226','2097','Hot Beef Sand','20' UNION ALL

  SELECT '4046','2009-06-12','223','2091','Tuna Sandwich','14' UNION ALL

  SELECT '4047','2009-06-12','237','3469','Pork Sandwich','13' UNION ALL

  SELECT '4048','2009-06-12','221','2086','BBQ Chx Sandwich','12' UNION ALL

  SELECT '4049','2009-06-12','227','2098','Brat Sand','11' UNION ALL

  SELECT '4061','2009-06-12','26','2713','Boiled Shrimp App','14' UNION ALL

  SELECT '4062','2009-06-12','35','3964','Calamari','14' UNION ALL

  SELECT '4065','2009-06-12','29','3957','Shrimp Poppers','8' UNION ALL

  SELECT '4069','2009-06-12','82','2037','Smoked Reg Prime','8' UNION ALL

  SELECT '4070','2009-06-12','89','2049','Pork Medallions','10' UNION ALL

  SELECT '4071','2009-06-12','88','2048','Caribbean Chicken','9' UNION ALL

  SELECT '4072','2009-06-12','81','2036','Prime Rib 8oz.','7' UNION ALL

  SELECT '4073','2009-06-12','90','2053','Salmon Fillet','5' UNION ALL

  SELECT '4074','2009-06-12','112','4101','Fish & Chips/Salad','4' UNION ALL

  SELECT '4075','2009-06-12','84','2040','Smoked Brew Prime','3' UNION ALL

  SELECT '4077','2009-06-12','83','2039','Ribeye','3' UNION ALL

  SELECT '4078','2009-06-12','114','4103','Shrimp & Salad','3' UNION ALL

  SELECT '4079','2009-06-12','85','2041','Filet','2' UNION ALL

  SELECT '4080','2009-06-12','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '4081','2009-06-12','106','4095','Sausage Platter/ Brewhouse','2' UNION ALL

  SELECT '4085','2009-06-12','111','4100','Rack/ Caesar','1' UNION ALL

  SELECT '4087','2009-06-12','104','4093','Smokehouse Combo/ Brewhouse','1' UNION ALL

  SELECT '4089','2009-06-12','116','4106','BBQ Chicken/ Brewhouse','1' UNION ALL

  SELECT '4090','2009-06-12','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '4091','2009-06-12','115','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '4092','2009-06-12','107','4096','Sausage Platter/ Caesar','1' UNION ALL

  SELECT '4097','2009-06-12','133','3507','Fish & Chips','18' UNION ALL

  SELECT '4098','2009-06-12','130','2052','Smokehouse Combo','11' UNION ALL

  SELECT '4099','2009-06-12','129','2047','Sausage Platter','12' UNION ALL

  SELECT '4100','2009-06-12','134','3934','Rack','7' UNION ALL

  SELECT '4101','2009-06-12','131','3498','Shrimp & Chips','10' UNION ALL

  SELECT '4102','2009-06-12','132','3501','Half Rack','4' UNION ALL

  SELECT '4103','2009-06-12','136','4108','Country Style Ribs','4' UNION ALL

  SELECT '4104','2009-06-12','135','4105','BBQ Chicken Breast','3' UNION ALL

  SELECT '4171','2009-06-12','1421','4662','Red Bull','11' UNION ALL

  SELECT '4189','2009-06-12','199','3972','Jamaican Salad','12' UNION ALL

  SELECT '4190','2009-06-12','200','3973','Greek Salad','9' UNION ALL

  SELECT '4192','2009-06-12','183','2027','Mill Salad/ Brisket','5' UNION ALL

  SELECT '4193','2009-06-12','182','2025','Chicken Caesar Salad','5' UNION ALL

  SELECT '4194','2009-06-12','185','2031','Mill Salad/ Chicken','4' UNION ALL

  SELECT '4196','2009-06-12','202','4264','Lg Brewhouse/Tuna','2' UNION ALL

  SELECT '4198','2009-06-12','201','4263','Lg Brewhouse/Chicken','2' UNION ALL

  SELECT '4249','2009-06-12','143','2035','Kid Fish','2' UNION ALL

  SELECT '4256','2009-06-12','410','2596','+ Chick Breast $2.99','2' UNION ALL

  SELECT '4304','2009-06-12','584','4072','+ Weisswurst','1' UNION ALL

  SELECT '4452','2009-06-13','236','3468','Grilled Prime Sandwich','35' UNION ALL

  SELECT '4454','2009-06-13','242','3732','Brisket Sandwich','40' UNION ALL

  SELECT '4455','2009-06-13','224','2094','Caribbean Chix Sand','35' UNION ALL

  SELECT '4456','2009-06-13','226','2097','Hot Beef Sand','26' UNION ALL

  SELECT '4457','2009-06-13','230','2884','Fish Sandwich','23' UNION ALL

  SELECT '4458','2009-06-13','237','3469','Pork Sandwich','24' UNION ALL

  SELECT '4460','2009-06-13','221','2086','BBQ Chx Sandwich','21' UNION ALL

  SELECT '4462','2009-06-13','223','2091','Tuna Sandwich','18' UNION ALL

  SELECT '4464','2009-06-13','227','2098','Brat Sand','13' UNION ALL

  SELECT '4475','2009-06-13','35','3964','Calamari','16' UNION ALL

  SELECT '4476','2009-06-13','26','2713','Boiled Shrimp App','10' UNION ALL

  SELECT '4479','2009-06-13','29','3957','Shrimp Poppers','9' UNION ALL

  SELECT '4483','2009-06-13','90','2053','Salmon Fillet','8' UNION ALL

  SELECT '4484','2009-06-13','89','2049','Pork Medallions','9' UNION ALL

  SELECT '4485','2009-06-13','83','2039','Ribeye','7' UNION ALL

  SELECT '4486','2009-06-13','88','2048','Caribbean Chicken','8' UNION ALL

  SELECT '4487','2009-06-13','86','2044','Mahi-Mahi','7' UNION ALL

  SELECT '4488','2009-06-13','82','2037','Smoked Reg Prime','6' UNION ALL

  SELECT '4489','2009-06-13','85','2041','Filet','4' UNION ALL

  SELECT '4490','2009-06-13','108','4097','Half Rack/Brewhouse','4' UNION ALL

  SELECT '4491','2009-06-13','81','2036','Prime Rib 8oz.','4' UNION ALL

  SELECT '4493','2009-06-13','116','4106','BBQ Chicken/ Brewhouse','3' UNION ALL

  SELECT '4494','2009-06-13','112','4101','Fish & Chips/Salad','3' UNION ALL

  SELECT '4495','2009-06-13','114','4103','Shrimp & Salad','2' UNION ALL

  SELECT '4499','2009-06-13','84','2040','Smoked Brew Prime','1' UNION ALL

  SELECT '4500','2009-06-13','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '4501','2009-06-13','115','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '4502','2009-06-13','118','4109','Country Style/Brewhouse','1' UNION ALL

  SELECT '4503','2009-06-13','119','4110','Country Style/Caesar','1' UNION ALL

  SELECT '4504','2009-06-13','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '4511','2009-06-13','133','3507','Fish & Chips','24' UNION ALL

  SELECT '4512','2009-06-13','132','3501','Half Rack','14' UNION ALL

  SELECT '4513','2009-06-13','131','3498','Shrimp & Chips','9' UNION ALL

  SELECT '4514','2009-06-13','134','3934','Rack','5' UNION ALL

  SELECT '4515','2009-06-13','135','4105','BBQ Chicken Breast','7' UNION ALL

  SELECT '4516','2009-06-13','136','4108','Country Style Ribs','7' UNION ALL

  SELECT '4517','2009-06-13','129','2047','Sausage Platter','5' UNION ALL

  SELECT '4518','2009-06-13','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '4519','2009-06-13','138','4342','Sausage Platter SUB','1' UNION ALL

  SELECT '4594','2009-06-13','199','3972','Jamaican Salad','17' UNION ALL

  SELECT '4595','2009-06-13','185','2031','Mill Salad/ Chicken','11' UNION ALL

  SELECT '4596','2009-06-13','200','3973','Greek Salad','8' UNION ALL

  SELECT '4597','2009-06-13','201','4263','Lg Brewhouse/Chicken','7' UNION ALL

  SELECT '4599','2009-06-13','182','2025','Chicken Caesar Salad','3' UNION ALL

  SELECT '4602','2009-06-13','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '4633','2009-06-13','1421','4662','Red Bull','10' UNION ALL

  SELECT '4655','2009-06-13','143','2035','Kid Fish','7' UNION ALL

  SELECT '4670','2009-06-13','410','2596','+ Chick Breast $2.99','2' UNION ALL

  SELECT '4861','2009-06-14','224','2094','Caribbean Chix Sand','28' UNION ALL

  SELECT '4863','2009-06-14','236','3468','Grilled Prime Sandwich','15' UNION ALL

  SELECT '4865','2009-06-14','223','2091','Tuna Sandwich','15' UNION ALL

  SELECT '4866','2009-06-14','230','2884','Fish Sandwich','14' UNION ALL

  SELECT '4867','2009-06-14','226','2097','Hot Beef Sand','9' UNION ALL

  SELECT '4869','2009-06-14','221','2086','BBQ Chx Sandwich','9' UNION ALL

  SELECT '4871','2009-06-14','237','3469','Pork Sandwich','8' UNION ALL

  SELECT '4872','2009-06-14','242','3732','Brisket Sandwich','7' UNION ALL

  SELECT '4873','2009-06-14','227','2098','Brat Sand','5' UNION ALL

  SELECT '4876','2009-06-14','133','3507','Fish & Chips','20' UNION ALL

  SELECT '4877','2009-06-14','129','2047','Sausage Platter','12' UNION ALL

  SELECT '4878','2009-06-14','130','2052','Smokehouse Combo','7' UNION ALL

  SELECT '4879','2009-06-14','134','3934','Rack','6' UNION ALL

  SELECT '4880','2009-06-14','136','4108','Country Style Ribs','9' UNION ALL

  SELECT '4881','2009-06-14','132','3501','Half Rack','7' UNION ALL

  SELECT '4882','2009-06-14','131','3498','Shrimp & Chips','7' UNION ALL

  SELECT '4883','2009-06-14','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '4893','2009-06-14','35','3964','Calamari','5' UNION ALL

  SELECT '4896','2009-06-14','29','3957','Shrimp Poppers','3' UNION ALL

  SELECT '4904','2009-06-14','199','3972','Jamaican Salad','14' UNION ALL

  SELECT '4905','2009-06-14','185','2031','Mill Salad/ Chicken','9' UNION ALL

  SELECT '4906','2009-06-14','200','3973','Greek Salad','10' UNION ALL

  SELECT '4910','2009-06-14','201','4263','Lg Brewhouse/Chicken','3' UNION ALL

  SELECT '4911','2009-06-14','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '4912','2009-06-14','182','2025','Chicken Caesar Salad','2' UNION ALL

  SELECT '4913','2009-06-14','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '4924','2009-06-14','81','2036','Prime Rib 8oz.','4' UNION ALL

  SELECT '4925','2009-06-14','85','2041','Filet','3' UNION ALL

  SELECT '4926','2009-06-14','82','2037','Smoked Reg Prime','3' UNION ALL

  SELECT '4927','2009-06-14','83','2039','Ribeye','3' UNION ALL

  SELECT '4928','2009-06-14','90','2053','Salmon Fillet','3' UNION ALL

  SELECT '4929','2009-06-14','88','2048','Caribbean Chicken','3' UNION ALL

  SELECT '4931','2009-06-14','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '4932','2009-06-14','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '4934','2009-06-14','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '4937','2009-06-14','89','2049','Pork Medallions','1' UNION ALL

  SELECT '4975','2009-06-14','143','2035','Kid Fish','8' UNION ALL

  SELECT '5036','2009-06-14','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '5174','2009-06-15','242','3732','Brisket Sandwich','18' UNION ALL

  SELECT '5175','2009-06-15','224','2094','Caribbean Chix Sand','18' UNION ALL

  SELECT '5176','2009-06-15','237','3469','Pork Sandwich','16' UNION ALL

  SELECT '5178','2009-06-15','236','3468','Grilled Prime Sandwich','11' UNION ALL

  SELECT '5179','2009-06-15','226','2097','Hot Beef Sand','12' UNION ALL

  SELECT '5180','2009-06-15','221','2086','BBQ Chx Sandwich','10' UNION ALL

  SELECT '5184','2009-06-15','223','2091','Tuna Sandwich','5' UNION ALL

  SELECT '5185','2009-06-15','227','2098','Brat Sand','5' UNION ALL

  SELECT '5187','2009-06-15','230','2884','Fish Sandwich','3' UNION ALL

  SELECT '5190','2009-06-15','26','2713','Boiled Shrimp App','24' UNION ALL

  SELECT '5195','2009-06-15','35','3964','Calamari','11' UNION ALL

  SELECT '5200','2009-06-15','29','3957','Shrimp Poppers','4' UNION ALL

  SELECT '5205','2009-06-15','82','2037','Smoked Reg Prime','8' UNION ALL

  SELECT '5206','2009-06-15','88','2048','Caribbean Chicken','6' UNION ALL

  SELECT '5207','2009-06-15','112','4101','Fish & Chips/Salad','5' UNION ALL

  SELECT '5209','2009-06-15','85','2041','Filet','3' UNION ALL

  SELECT '5211','2009-06-15','86','2044','Mahi-Mahi','3' UNION ALL

  SELECT '5212','2009-06-15','84','2040','Smoked Brew Prime','2' UNION ALL

  SELECT '5213','2009-06-15','90','2053','Salmon Fillet','2' UNION ALL

  SELECT '5215','2009-06-15','89','2049','Pork Medallions','2' UNION ALL

  SELECT '5217','2009-06-15','83','2039','Ribeye','1' UNION ALL

  SELECT '5218','2009-06-15','109','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '5219','2009-06-15','81','2036','Prime Rib 8oz.','1' UNION ALL

  SELECT '5220','2009-06-15','116','4106','BBQ Chicken/ Brewhouse','1' UNION ALL

  SELECT '5221','2009-06-15','114','4103','Shrimp & Salad','1' UNION ALL

  SELECT '5222','2009-06-15','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '5223','2009-06-15','107','4096','Sausage Platter/ Caesar','1' UNION ALL

  SELECT '5229','2009-06-15','133','3507','Fish & Chips','13' UNION ALL

  SELECT '5230','2009-06-15','130','2052','Smokehouse Combo','8' UNION ALL

  SELECT '5231','2009-06-15','135','4105','BBQ Chicken Breast','7' UNION ALL

  SELECT '5232','2009-06-15','132','3501','Half Rack','5' UNION ALL

  SELECT '5233','2009-06-15','134','3934','Rack','2' UNION ALL

  SELECT '5234','2009-06-15','136','4108','Country Style Ribs','3' UNION ALL

  SELECT '5235','2009-06-15','129','2047','Sausage Platter','3' UNION ALL

  SELECT '5236','2009-06-15','131','3498','Shrimp & Chips','2' UNION ALL

  SELECT '5237','2009-06-15','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '5265','2009-06-15','199','3972','Jamaican Salad','6' UNION ALL

  SELECT '5266','2009-06-15','182','2025','Chicken Caesar Salad','5' UNION ALL

  SELECT '5268','2009-06-15','185','2031','Mill Salad/ Chicken','4' UNION ALL

  SELECT '5269','2009-06-15','200','3973','Greek Salad','4' UNION ALL

  SELECT '5271','2009-06-15','202','4264','Lg Brewhouse/Tuna','2' UNION ALL

  SELECT '5272','2009-06-15','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '5275','2009-06-15','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '5276','2009-06-15','201','4263','Lg Brewhouse/Chicken','1' UNION ALL

  SELECT '5286','2009-06-15','1421','4662','Red Bull','3' UNION ALL

  SELECT '5347','2009-06-15','143','2035','Kid Fish','3' UNION ALL

  SELECT '5359','2009-06-15','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '5520','2009-06-16','236','3468','Grilled Prime Sandwich','17' UNION ALL

  SELECT '5522','2009-06-16','226','2097','Hot Beef Sand','14' UNION ALL

  SELECT '5523','2009-06-16','224','2094','Caribbean Chix Sand','15' UNION ALL

  SELECT '5525','2009-06-16','223','2091','Tuna Sandwich','13' UNION ALL

  SELECT '5526','2009-06-16','230','2884','Fish Sandwich','12' UNION ALL

  SELECT '5527','2009-06-16','221','2086','BBQ Chx Sandwich','13' UNION ALL

  SELECT '5528','2009-06-16','242','3732','Brisket Sandwich','12' UNION ALL

  SELECT '5529','2009-06-16','237','3469','Pork Sandwich','10' UNION ALL

  SELECT '5531','2009-06-16','227','2098','Brat Sand','5' UNION ALL

  SELECT '5534','2009-06-16','90','2053','Salmon Fillet','12' UNION ALL

  SELECT '5535','2009-06-16','82','2037','Smoked Reg Prime','9' UNION ALL

  SELECT '5536','2009-06-16','88','2048','Caribbean Chicken','10' UNION ALL

  SELECT '5537','2009-06-16','86','2044','Mahi-Mahi','6' UNION ALL

  SELECT '5538','2009-06-16','84','2040','Smoked Brew Prime','5' UNION ALL

  SELECT '5539','2009-06-16','89','2049','Pork Medallions','6' UNION ALL

  SELECT '5540','2009-06-16','81','2036','Prime Rib 8oz.','5' UNION ALL

  SELECT '5541','2009-06-16','83','2039','Ribeye','4' UNION ALL

  SELECT '5542','2009-06-16','85','2041','Filet','3' UNION ALL

  SELECT '5543','2009-06-16','113','4102','Fish & Chips/ Caesar','3' UNION ALL

  SELECT '5544','2009-06-16','114','4103','Shrimp & Salad','3' UNION ALL

  SELECT '5545','2009-06-16','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '5550','2009-06-16','118','4109','Country Style/Brewhouse','1' UNION ALL

  SELECT '5551','2009-06-16','119','4110','Country Style/Caesar','1' UNION ALL

  SELECT '5567','2009-06-16','35','3964','Calamari','4' UNION ALL

  SELECT '5569','2009-06-16','29','3957','Shrimp Poppers','4' UNION ALL

  SELECT '5570','2009-06-16','26','2713','Boiled Shrimp App','5' UNION ALL

  SELECT '5575','2009-06-16','133','3507','Fish & Chips','22' UNION ALL

  SELECT '5576','2009-06-16','135','4105','BBQ Chicken Breast','9' UNION ALL

  SELECT '5577','2009-06-16','131','3498','Shrimp & Chips','7' UNION ALL

  SELECT '5578','2009-06-16','129','2047','Sausage Platter','6' UNION ALL

  SELECT '5579','2009-06-16','136','4108','Country Style Ribs','4' UNION ALL

  SELECT '5580','2009-06-16','132','3501','Half Rack','3' UNION ALL

  SELECT '5581','2009-06-16','134','3934','Rack','2' UNION ALL

  SELECT '5582','2009-06-16','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '5589','2009-06-16','199','3972','Jamaican Salad','9' UNION ALL

  SELECT '5590','2009-06-16','185','2031','Mill Salad/ Chicken','7' UNION ALL

  SELECT '5594','2009-06-16','200','3973','Greek Salad','4' UNION ALL

  SELECT '5595','2009-06-16','183','2027','Mill Salad/ Brisket','3' UNION ALL

  SELECT '5597','2009-06-16','182','2025','Chicken Caesar Salad','1' UNION ALL

  SELECT '5598','2009-06-16','201','4263','Lg Brewhouse/Chicken','1' UNION ALL

  SELECT '5606','2009-06-16','1421','4662','Red Bull','7' UNION ALL

  SELECT '5692','2009-06-16','410','2596','+ Chick Breast $2.99','4' UNION ALL

  SELECT '5750','2009-06-16','143','2035','Kid Fish','3' UNION ALL

  SELECT '5880','2009-06-17','242','3732','Brisket Sandwich','29' UNION ALL

  SELECT '5881','2009-06-17','224','2094','Caribbean Chix Sand','28' UNION ALL

  SELECT '5882','2009-06-17','236','3468','Grilled Prime Sandwich','16' UNION ALL

  SELECT '5883','2009-06-17','230','2884','Fish Sandwich','15' UNION ALL

  SELECT '5885','2009-06-17','226','2097','Hot Beef Sand','13' UNION ALL

  SELECT '5886','2009-06-17','237','3469','Pork Sandwich','14' UNION ALL

  SELECT '5887','2009-06-17','223','2091','Tuna Sandwich','12' UNION ALL

  SELECT '5889','2009-06-17','221','2086','BBQ Chx Sandwich','8' UNION ALL

  SELECT '5891','2009-06-17','227','2098','Brat Sand','4' UNION ALL

  SELECT '5897','2009-06-17','35','3964','Calamari','16' UNION ALL

  SELECT '5902','2009-06-17','26','2713','Boiled Shrimp App','15' UNION ALL

  SELECT '5906','2009-06-17','29','3957','Shrimp Poppers','7' UNION ALL

  SELECT '5917','2009-06-17','133','3507','Fish & Chips','28' UNION ALL

  SELECT '5918','2009-06-17','135','4105','BBQ Chicken Breast','13' UNION ALL

  SELECT '5919','2009-06-17','131','3498','Shrimp & Chips','8' UNION ALL

  SELECT '5920','2009-06-17','132','3501','Half Rack','4' UNION ALL

  SELECT '5921','2009-06-17','129','2047','Sausage Platter','4' UNION ALL

  SELECT '5922','2009-06-17','134','3934','Rack','2' UNION ALL

  SELECT '5923','2009-06-17','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '5924','2009-06-17','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '5925','2009-06-17','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '5927','2009-06-17','90','2053','Salmon Fillet','10' UNION ALL

  SELECT '5928','2009-06-17','88','2048','Caribbean Chicken','7' UNION ALL

  SELECT '5929','2009-06-17','83','2039','Ribeye','5' UNION ALL

  SELECT '5930','2009-06-17','82','2037','Smoked Reg Prime','4' UNION ALL

  SELECT '5931','2009-06-17','89','2049','Pork Medallions','5' UNION ALL

  SELECT '5933','2009-06-17','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '5934','2009-06-17','81','2036','Prime Rib 8oz.','2' UNION ALL

  SELECT '5935','2009-06-17','115','4104','Shrimp & Caesar','2' UNION ALL

  SELECT '5936','2009-06-17','114','4103','Shrimp & Salad','2' UNION ALL

  SELECT '5940','2009-06-17','105','4094','Smokehouse Combo/Caesar','1' UNION ALL

  SELECT '5941','2009-06-17','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '5946','2009-06-17','199','3972','Jamaican Salad','16' UNION ALL

  SELECT '5947','2009-06-17','185','2031','Mill Salad/ Chicken','7' UNION ALL

  SELECT '5949','2009-06-17','200','3973','Greek Salad','7' UNION ALL

  SELECT '5950','2009-06-17','183','2027','Mill Salad/ Brisket','3' UNION ALL

  SELECT '5952','2009-06-17','182','2025','Chicken Caesar Salad','3' UNION ALL

  SELECT '5953','2009-06-17','201','4263','Lg Brewhouse/Chicken','2' UNION ALL

  SELECT '5955','2009-06-17','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '5971','2009-06-17','1421','4662','Red Bull','7' UNION ALL

  SELECT '6070','2009-06-17','143','2035','Kid Fish','4' UNION ALL

  SELECT '6076','2009-06-17','410','2596','+ Chick Breast $2.99','3' UNION ALL

  SELECT '6257','2009-06-18','236','3468','Grilled Prime Sandwich','13' UNION ALL

  SELECT '6259','2009-06-18','223','2091','Tuna Sandwich','14' UNION ALL

  SELECT '6260','2009-06-18','237','3469','Pork Sandwich','15' UNION ALL

  SELECT '6261','2009-06-18','230','2884','Fish Sandwich','13' UNION ALL

  SELECT '6262','2009-06-18','242','3732','Brisket Sandwich','14' UNION ALL

  SELECT '6263','2009-06-18','221','2086','BBQ Chx Sandwich','14' UNION ALL

  SELECT '6264','2009-06-18','224','2094','Caribbean Chix Sand','14' UNION ALL

  SELECT '6267','2009-06-18','226','2097','Hot Beef Sand','9' UNION ALL

  SELECT '6270','2009-06-18','227','2098','Brat Sand','1' UNION ALL

  SELECT '6276','2009-06-18','26','2713','Boiled Shrimp App','11' UNION ALL

  SELECT '6277','2009-06-18','35','3964','Calamari','11' UNION ALL

  SELECT '6283','2009-06-18','29','3957','Shrimp Poppers','4' UNION ALL

  SELECT '6288','2009-06-18','86','2044','Mahi-Mahi','8' UNION ALL

  SELECT '6289','2009-06-18','82','2037','Smoked Reg Prime','4' UNION ALL

  SELECT '6290','2009-06-18','83','2039','Ribeye','4' UNION ALL

  SELECT '6291','2009-06-18','89','2049','Pork Medallions','5' UNION ALL

  SELECT '6292','2009-06-18','90','2053','Salmon Fillet','4' UNION ALL

  SELECT '6293','2009-06-18','81','2036','Prime Rib 8oz.','4' UNION ALL

  SELECT '6294','2009-06-18','88','2048','Caribbean Chicken','4' UNION ALL

  SELECT '6295','2009-06-18','126','4341','Shrimp & Chips SUB','3' UNION ALL

  SELECT '6296','2009-06-18','85','2041','Filet','2' UNION ALL

  SELECT '6298','2009-06-18','115','4104','Shrimp & Caesar','2' UNION ALL

  SELECT '6300','2009-06-18','104','4093','Smokehouse Combo/ Brewhouse','1' UNION ALL

  SELECT '6302','2009-06-18','112','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '6308','2009-06-18','200','3973','Greek Salad','12' UNION ALL

  SELECT '6309','2009-06-18','199','3972','Jamaican Salad','8' UNION ALL

  SELECT '6310','2009-06-18','201','4263','Lg Brewhouse/Chicken','8' UNION ALL

  SELECT '6311','2009-06-18','185','2031','Mill Salad/ Chicken','6' UNION ALL

  SELECT '6312','2009-06-18','183','2027','Mill Salad/ Brisket','6' UNION ALL

  SELECT '6315','2009-06-18','202','4264','Lg Brewhouse/Tuna','4' UNION ALL

  SELECT '6316','2009-06-18','182','2025','Chicken Caesar Salad','4' UNION ALL

  SELECT '6354','2009-06-18','133','3507','Fish & Chips','16' UNION ALL

  SELECT '6355','2009-06-18','132','3501','Half Rack','5' UNION ALL

  SELECT '6356','2009-06-18','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '6357','2009-06-18','129','2047','Sausage Platter','5' UNION ALL

  SELECT '6358','2009-06-18','131','3498','Shrimp & Chips','2' UNION ALL

  SELECT '6359','2009-06-18','130','2052','Smokehouse Combo','1' UNION ALL

  SELECT '6360','2009-06-18','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '6380','2009-06-18','1421','4662','Red Bull','5' UNION ALL

  SELECT '6600','2009-06-19','224','2094','Caribbean Chix Sand','30' UNION ALL

  SELECT '6602','2009-06-19','223','2091','Tuna Sandwich','20' UNION ALL

  SELECT '6604','2009-06-19','230','2884','Fish Sandwich','18' UNION ALL

  SELECT '6605','2009-06-19','242','3732','Brisket Sandwich','19' UNION ALL

  SELECT '6606','2009-06-19','237','3469','Pork Sandwich','19' UNION ALL

  SELECT '6607','2009-06-19','236','3468','Grilled Prime Sandwich','15' UNION ALL

  SELECT '6608','2009-06-19','221','2086','BBQ Chx Sandwich','15' UNION ALL

  SELECT '6610','2009-06-19','227','2098','Brat Sand','9' UNION ALL

  SELECT '6611','2009-06-19','226','2097','Hot Beef Sand','7' UNION ALL

  SELECT '6620','2009-06-19','26','2713','Boiled Shrimp App','24' UNION ALL

  SELECT '6625','2009-06-19','35','3964','Calamari','17' UNION ALL

  SELECT '6629','2009-06-19','29','3957','Shrimp Poppers','10' UNION ALL

  SELECT '6680','2009-06-19','90','2053','Salmon Fillet','9' UNION ALL

  SELECT '6681','2009-06-19','83','2039','Ribeye','8' UNION ALL

  SELECT '6682','2009-06-19','86','2044','Mahi-Mahi','7' UNION ALL

  SELECT '6685','2009-06-19','85','2041','Filet','4' UNION ALL

  SELECT '6686','2009-06-19','82','2037','Smoked Reg Prime','4' UNION ALL

  SELECT '6687','2009-06-19','89','2049','Pork Medallions','3' UNION ALL

  SELECT '6689','2009-06-19','81','2036','Prime Rib 8oz.','2' UNION ALL

  SELECT '6690','2009-06-19','116','4106','BBQ Chicken/ Brewhouse','2' UNION ALL

  SELECT '6691','2009-06-19','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '6692','2009-06-19','114','4103','Shrimp & Salad','2' UNION ALL

  SELECT '6693','2009-06-19','88','2048','Caribbean Chicken','2' UNION ALL

  SELECT '6695','2009-06-19','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '6696','2009-06-19','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '6700','2009-06-19','133','3507','Fish & Chips','24' UNION ALL

  SELECT '6701','2009-06-19','131','3498','Shrimp & Chips','11' UNION ALL

  SELECT '6702','2009-06-19','130','2052','Smokehouse Combo','4' UNION ALL

  SELECT '6703','2009-06-19','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '6704','2009-06-19','134','3934','Rack','2' UNION ALL

  SELECT '6705','2009-06-19','136','4108','Country Style Ribs','3' UNION ALL

  SELECT '6706','2009-06-19','129','2047','Sausage Platter','3' UNION ALL

  SELECT '6707','2009-06-19','137','4335','Fish & Chips/ SUB','2' UNION ALL

  SELECT '6715','2009-06-19','199','3972','Jamaican Salad','12' UNION ALL

  SELECT '6716','2009-06-19','200','3973','Greek Salad','12' UNION ALL

  SELECT '6717','2009-06-19','185','2031','Mill Salad/ Chicken','8' UNION ALL

  SELECT '6720','2009-06-19','201','4263','Lg Brewhouse/Chicken','5' UNION ALL

  SELECT '6721','2009-06-19','183','2027','Mill Salad/ Brisket','4' UNION ALL

  SELECT '6722','2009-06-19','182','2025','Chicken Caesar Salad','4' UNION ALL

  SELECT '6724','2009-06-19','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '6725','2009-06-19','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '6745','2009-06-19','1421','4662','Red Bull','7' UNION ALL

  SELECT '6798','2009-06-19','143','2035','Kid Fish','3' UNION ALL

  SELECT '7015','2009-06-20','224','2094','Caribbean Chix Sand','37' UNION ALL

  SELECT '7016','2009-06-20','242','3732','Brisket Sandwich','35' UNION ALL

  SELECT '7017','2009-06-20','236','3468','Grilled Prime Sandwich','24' UNION ALL

  SELECT '7018','2009-06-20','230','2884','Fish Sandwich','25' UNION ALL

  SELECT '7019','2009-06-20','223','2091','Tuna Sandwich','22' UNION ALL

  SELECT '7023','2009-06-20','221','2086','BBQ Chx Sandwich','16' UNION ALL

  SELECT '7025','2009-06-20','227','2098','Brat Sand','13' UNION ALL

  SELECT '7026','2009-06-20','226','2097','Hot Beef Sand','11' UNION ALL

  SELECT '7027','2009-06-20','237','3469','Pork Sandwich','10' UNION ALL

  SELECT '7035','2009-06-20','35','3964','Calamari','17' UNION ALL

  SELECT '7039','2009-06-20','29','3957','Shrimp Poppers','11' UNION ALL

  SELECT '7041','2009-06-20','26','2713','Boiled Shrimp App','8' UNION ALL

  SELECT '7048','2009-06-20','82','2037','Smoked Reg Prime','12' UNION ALL

  SELECT '7049','2009-06-20','81','2036','Prime Rib 8oz.','13' UNION ALL

  SELECT '7050','2009-06-20','90','2053','Salmon Fillet','9' UNION ALL

  SELECT '7051','2009-06-20','85','2041','Filet','6' UNION ALL

  SELECT '7052','2009-06-20','88','2048','Caribbean Chicken','7' UNION ALL

  SELECT '7053','2009-06-20','89','2049','Pork Medallions','7' UNION ALL

  SELECT '7055','2009-06-20','112','4101','Fish & Chips/Salad','5' UNION ALL

  SELECT '7056','2009-06-20','86','2044','Mahi-Mahi','4' UNION ALL

  SELECT '7057','2009-06-20','115','4104','Shrimp & Caesar','3' UNION ALL

  SELECT '7058','2009-06-20','114','4103','Shrimp & Salad','3' UNION ALL

  SELECT '7062','2009-06-20','83','2039','Ribeye','2' UNION ALL

  SELECT '7064','2009-06-20','126','4341','Shrimp & Chips SUB','2' UNION ALL

  SELECT '7065','2009-06-20','84','2040','Smoked Brew Prime','1' UNION ALL

  SELECT '7066','2009-06-20','109','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '7067','2009-06-20','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '7072','2009-06-20','133','3507','Fish & Chips','53' UNION ALL

  SELECT '7073','2009-06-20','129','2047','Sausage Platter','9' UNION ALL

  SELECT '7074','2009-06-20','132','3501','Half Rack','8' UNION ALL

  SELECT '7075','2009-06-20','134','3934','Rack','5' UNION ALL

  SELECT '7076','2009-06-20','136','4108','Country Style Ribs','7' UNION ALL

  SELECT '7077','2009-06-20','131','3498','Shrimp & Chips','6' UNION ALL

  SELECT '7078','2009-06-20','130','2052','Smokehouse Combo','3' UNION ALL

  SELECT '7079','2009-06-20','135','4105','BBQ Chicken Breast','3' UNION ALL

  SELECT '7080','2009-06-20','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '7136','2009-06-20','185','2031','Mill Salad/ Chicken','10' UNION ALL

  SELECT '7137','2009-06-20','199','3972','Jamaican Salad','10' UNION ALL

  SELECT '7138','2009-06-20','200','3973','Greek Salad','10' UNION ALL

  SELECT '7140','2009-06-20','201','4263','Lg Brewhouse/Chicken','5' UNION ALL

  SELECT '7142','2009-06-20','182','2025','Chicken Caesar Salad','4' UNION ALL

  SELECT '7143','2009-06-20','183','2027','Mill Salad/ Brisket','3' UNION ALL

  SELECT '7146','2009-06-20','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '7172','2009-06-20','1421','4662','Red Bull','25' UNION ALL

  SELECT '7200','2009-06-20','143','2035','Kid Fish','10' UNION ALL

  SELECT '7225','2009-06-20','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '7412','2009-06-21','236','3468','Grilled Prime Sandwich','22' UNION ALL

  SELECT '7414','2009-06-21','242','3732','Brisket Sandwich','23' UNION ALL

  SELECT '7416','2009-06-21','223','2091','Tuna Sandwich','19' UNION ALL

  SELECT '7417','2009-06-21','226','2097','Hot Beef Sand','17' UNION ALL

  SELECT '7419','2009-06-21','224','2094','Caribbean Chix Sand','15' UNION ALL

  SELECT '7420','2009-06-21','230','2884','Fish Sandwich','12' UNION ALL

  SELECT '7421','2009-06-21','221','2086','BBQ Chx Sandwich','10' UNION ALL

  SELECT '7422','2009-06-21','237','3469','Pork Sandwich','10' UNION ALL

  SELECT '7423','2009-06-21','227','2098','Brat Sand','7' UNION ALL

  SELECT '7447','2009-06-21','35','3964','Calamari','9' UNION ALL

  SELECT '7450','2009-06-21','26','2713','Boiled Shrimp App','6' UNION ALL

  SELECT '7455','2009-06-21','29','3957','Shrimp Poppers','3' UNION ALL

  SELECT '7460','2009-06-21','83','2039','Ribeye','7' UNION ALL

  SELECT '7461','2009-06-21','82','2037','Smoked Reg Prime','6' UNION ALL

  SELECT '7462','2009-06-21','88','2048','Caribbean Chicken','7' UNION ALL

  SELECT '7463','2009-06-21','86','2044','Mahi-Mahi','6' UNION ALL

  SELECT '7464','2009-06-21','89','2049','Pork Medallions','7' UNION ALL

  SELECT '7465','2009-06-21','84','2040','Smoked Brew Prime','3' UNION ALL

  SELECT '7466','2009-06-21','112','4101','Fish & Chips/Salad','3' UNION ALL

  SELECT '7468','2009-06-21','85','2041','Filet','2' UNION ALL

  SELECT '7469','2009-06-21','90','2053','Salmon Fillet','2' UNION ALL

  SELECT '7470','2009-06-21','109','4098','Half Rack/ Caesar','2' UNION ALL

  SELECT '7471','2009-06-21','118','4109','Country Style/Brewhouse','2' UNION ALL

  SELECT '7472','2009-06-21','107','4096','Sausage Platter/ Caesar','2' UNION ALL

  SELECT '7475','2009-06-21','126','4341','Shrimp & Chips SUB','2' UNION ALL

  SELECT '7477','2009-06-21','110','4099','Rack/ Salad','1' UNION ALL

  SELECT '7478','2009-06-21','116','4106','BBQ Chicken/ Brewhouse','1' UNION ALL

  SELECT '7479','2009-06-21','117','4107','BBQ Chicken/ Caesar','1' UNION ALL

  SELECT '7480','2009-06-21','115','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '7486','2009-06-21','133','3507','Fish & Chips','28' UNION ALL

  SELECT '7487','2009-06-21','129','2047','Sausage Platter','14' UNION ALL

  SELECT '7488','2009-06-21','131','3498','Shrimp & Chips','9' UNION ALL

  SELECT '7489','2009-06-21','132','3501','Half Rack','7' UNION ALL

  SELECT '7490','2009-06-21','130','2052','Smokehouse Combo','4' UNION ALL

  SELECT '7491','2009-06-21','134','3934','Rack','3' UNION ALL

  SELECT '7492','2009-06-21','135','4105','BBQ Chicken Breast','3' UNION ALL

  SELECT '7493','2009-06-21','136','4108','Country Style Ribs','3' UNION ALL

  SELECT '7504','2009-06-21','1421','4662','Red Bull','1' UNION ALL

  SELECT '7511','2009-06-21','185','2031','Mill Salad/ Chicken','9' UNION ALL

  SELECT '7512','2009-06-21','200','3973','Greek Salad','10' UNION ALL

  SELECT '7513','2009-06-21','199','3972','Jamaican Salad','7' UNION ALL

  SELECT '7514','2009-06-21','183','2027','Mill Salad/ Brisket','7' UNION ALL

  SELECT '7515','2009-06-21','182','2025','Chicken Caesar Salad','5' UNION ALL

  SELECT '7517','2009-06-21','202','4264','Lg Brewhouse/Tuna','2' UNION ALL

  SELECT '7520','2009-06-21','201','4263','Lg Brewhouse/Chicken','2' UNION ALL

  SELECT '7575','2009-06-21','143','2035','Kid Fish','6' UNION ALL

  SELECT '7775','2009-06-22','236','3468','Grilled Prime Sandwich','20' UNION ALL

  SELECT '7776','2009-06-22','230','2884','Fish Sandwich','16' UNION ALL

  SELECT '7777','2009-06-22','224','2094','Caribbean Chix Sand','17' UNION ALL

  SELECT '7778','2009-06-22','242','3732','Brisket Sandwich','16' UNION ALL

  SELECT '7779','2009-06-22','226','2097','Hot Beef Sand','14' UNION ALL

  SELECT '7780','2009-06-22','221','2086','BBQ Chx Sandwich','14' UNION ALL

  SELECT '7782','2009-06-22','223','2091','Tuna Sandwich','8' UNION ALL

  SELECT '7784','2009-06-22','237','3469','Pork Sandwich','8' UNION ALL

  SELECT '7787','2009-06-22','227','2098','Brat Sand','3' UNION ALL

  SELECT '7801','2009-06-22','82','2037','Smoked Reg Prime','6' UNION ALL

  SELECT '7802','2009-06-22','90','2053','Salmon Fillet','6' UNION ALL

  SELECT '7803','2009-06-22','83','2039','Ribeye','5' UNION ALL

  SELECT '7804','2009-06-22','108','4097','Half Rack/Brewhouse','5' UNION ALL

  SELECT '7805','2009-06-22','89','2049','Pork Medallions','5' UNION ALL

  SELECT '7806','2009-06-22','85','2041','Filet','3' UNION ALL

  SELECT '7807','2009-06-22','86','2044','Mahi-Mahi','3' UNION ALL

  SELECT '7808','2009-06-22','81','2036','Prime Rib 8oz.','3' UNION ALL

  SELECT '7809','2009-06-22','88','2048','Caribbean Chicken','3' UNION ALL

  SELECT '7810','2009-06-22','122','4336','Fish & Chips/ Salad SUB','2' UNION ALL

  SELECT '7811','2009-06-22','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '7815','2009-06-22','118','4109','Country Style/Brewhouse','1' UNION ALL

  SELECT '7816','2009-06-22','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '7821','2009-06-22','26','2713','Boiled Shrimp App','15' UNION ALL

  SELECT '7824','2009-06-22','35','3964','Calamari','14' UNION ALL

  SELECT '7832','2009-06-22','29','3957','Shrimp Poppers','5' UNION ALL

  SELECT '7837','2009-06-22','133','3507','Fish & Chips','18' UNION ALL

  SELECT '7838','2009-06-22','131','3498','Shrimp & Chips','11' UNION ALL

  SELECT '7839','2009-06-22','129','2047','Sausage Platter','7' UNION ALL

  SELECT '7840','2009-06-22','132','3501','Half Rack','6' UNION ALL

  SELECT '7841','2009-06-22','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '7842','2009-06-22','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '7843','2009-06-22','134','3934','Rack','1' UNION ALL

  SELECT '7845','2009-06-22','199','3972','Jamaican Salad','10' UNION ALL

  SELECT '7846','2009-06-22','200','3973','Greek Salad','10' UNION ALL

  SELECT '7848','2009-06-22','185','2031','Mill Salad/ Chicken','7' UNION ALL

  SELECT '7849','2009-06-22','201','4263','Lg Brewhouse/Chicken','5' UNION ALL

  SELECT '7850','2009-06-22','182','2025','Chicken Caesar Salad','4' UNION ALL

  SELECT '7851','2009-06-22','183','2027','Mill Salad/ Brisket','3' UNION ALL

  SELECT '7852','2009-06-22','202','4264','Lg Brewhouse/Tuna','2' UNION ALL

  SELECT '7906','2009-06-22','1421','4662','Red Bull','9' UNION ALL

  SELECT '7952','2009-06-22','143','2035','Kid Fish','1' UNION ALL

  SELECT '7978','2009-06-22','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '8115','2009-06-23','236','3468','Grilled Prime Sandwich','17' UNION ALL

  SELECT '8116','2009-06-23','242','3732','Brisket Sandwich','16' UNION ALL

  SELECT '8117','2009-06-23','224','2094','Caribbean Chix Sand','12' UNION ALL

  SELECT '8118','2009-06-23','226','2097','Hot Beef Sand','10' UNION ALL

  SELECT '8119','2009-06-23','221','2086','BBQ Chx Sandwich','11' UNION ALL

  SELECT '8120','2009-06-23','230','2884','Fish Sandwich','9' UNION ALL

  SELECT '8121','2009-06-23','223','2091','Tuna Sandwich','9' UNION ALL

  SELECT '8122','2009-06-23','237','3469','Pork Sandwich','8' UNION ALL

  SELECT '8126','2009-06-23','227','2098','Brat Sand','2' UNION ALL

  SELECT '8130','2009-06-23','35','3964','Calamari','12' UNION ALL

  SELECT '8137','2009-06-23','29','3957','Shrimp Poppers','5' UNION ALL

  SELECT '8138','2009-06-23','26','2713','Boiled Shrimp App','5' UNION ALL

  SELECT '8148','2009-06-23','133','3507','Fish & Chips','23' UNION ALL

  SELECT '8149','2009-06-23','132','3501','Half Rack','9' UNION ALL

  SELECT '8150','2009-06-23','129','2047','Sausage Platter','7' UNION ALL

  SELECT '8151','2009-06-23','130','2052','Smokehouse Combo','4' UNION ALL

  SELECT '8152','2009-06-23','135','4105','BBQ Chicken Breast','4' UNION ALL

  SELECT '8153','2009-06-23','131','3498','Shrimp & Chips','4' UNION ALL

  SELECT '8154','2009-06-23','134','3934','Rack','2' UNION ALL

  SELECT '8155','2009-06-23','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '8156','2009-06-23','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '8158','2009-06-23','86','2044','Mahi-Mahi','4' UNION ALL

  SELECT '8159','2009-06-23','82','2037','Smoked Reg Prime','3' UNION ALL

  SELECT '8160','2009-06-23','90','2053','Salmon Fillet','3' UNION ALL

  SELECT '8161','2009-06-23','108','4097','Half Rack/Brewhouse','3' UNION ALL

  SELECT '8162','2009-06-23','88','2048','Caribbean Chicken','3' UNION ALL

  SELECT '8163','2009-06-23','89','2049','Pork Medallions','3' UNION ALL

  SELECT '8167','2009-06-23','110','4099','Rack/ Salad','1' UNION ALL

  SELECT '8168','2009-06-23','85','2041','Filet','1' UNION ALL

  SELECT '8169','2009-06-23','83','2039','Ribeye','1' UNION ALL

  SELECT '8171','2009-06-23','109','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '8172','2009-06-23','81','2036','Prime Rib 8oz.','1' UNION ALL

  SELECT '8173','2009-06-23','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '8174','2009-06-23','112','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '8175','2009-06-23','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '8177','2009-06-23','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '8182','2009-06-23','200','3973','Greek Salad','12' UNION ALL

  SELECT '8183','2009-06-23','199','3972','Jamaican Salad','9' UNION ALL

  SELECT '8184','2009-06-23','185','2031','Mill Salad/ Chicken','5' UNION ALL

  SELECT '8185','2009-06-23','182','2025','Chicken Caesar Salad','5' UNION ALL

  SELECT '8186','2009-06-23','201','4263','Lg Brewhouse/Chicken','5' UNION ALL

  SELECT '8188','2009-06-23','202','4264','Lg Brewhouse/Tuna','2' UNION ALL

  SELECT '8192','2009-06-23','183','2027','Mill Salad/ Brisket','1' UNION ALL

  SELECT '8226','2009-06-23','1421','4662','Red Bull','1' UNION ALL

  SELECT '8302','2009-06-23','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '8463','2009-06-24','82','2037','Smoked Reg Prime','12' UNION ALL

  SELECT '8464','2009-06-24','83','2039','Ribeye','8' UNION ALL

  SELECT '8465','2009-06-24','86','2044','Mahi-Mahi','8' UNION ALL

  SELECT '8466','2009-06-24','85','2041','Filet','5' UNION ALL

  SELECT '8467','2009-06-24','90','2053','Salmon Fillet','4' UNION ALL

  SELECT '8469','2009-06-24','88','2048','Caribbean Chicken','3' UNION ALL

  SELECT '8471','2009-06-24','89','2049','Pork Medallions','3' UNION ALL

  SELECT '8473','2009-06-24','84','2040','Smoked Brew Prime','2' UNION ALL

  SELECT '8474','2009-06-24','113','4102','Fish & Chips/ Caesar','2' UNION ALL

  SELECT '8476','2009-06-24','104','4093','Smokehouse Combo/ Brewhouse','1' UNION ALL

  SELECT '8477','2009-06-24','105','4094','Smokehouse Combo/Caesar','1' UNION ALL

  SELECT '8479','2009-06-24','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '8482','2009-06-24','224','2094','Caribbean Chix Sand','19' UNION ALL

  SELECT '8483','2009-06-24','226','2097','Hot Beef Sand','13' UNION ALL

  SELECT '8485','2009-06-24','230','2884','Fish Sandwich','10' UNION ALL

  SELECT '8486','2009-06-24','242','3732','Brisket Sandwich','10' UNION ALL

  SELECT '8487','2009-06-24','236','3468','Grilled Prime Sandwich','8' UNION ALL

  SELECT '8489','2009-06-24','223','2091','Tuna Sandwich','8' UNION ALL

  SELECT '8490','2009-06-24','237','3469','Pork Sandwich','8' UNION ALL

  SELECT '8494','2009-06-24','227','2098','Brat Sand','4' UNION ALL

  SELECT '8495','2009-06-24','221','2086','BBQ Chx Sandwich','4' UNION ALL

  SELECT '8501','2009-06-24','26','2713','Boiled Shrimp App','12' UNION ALL

  SELECT '8503','2009-06-24','35','3964','Calamari','12' UNION ALL

  SELECT '8506','2009-06-24','29','3957','Shrimp Poppers','7' UNION ALL

  SELECT '8513','2009-06-24','133','3507','Fish & Chips','21' UNION ALL

  SELECT '8514','2009-06-24','131','3498','Shrimp & Chips','10' UNION ALL

  SELECT '8515','2009-06-24','129','2047','Sausage Platter','7' UNION ALL

  SELECT '8516','2009-06-24','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '8517','2009-06-24','132','3501','Half Rack','4' UNION ALL

  SELECT '8518','2009-06-24','136','4108','Country Style Ribs','4' UNION ALL

  SELECT '8519','2009-06-24','134','3934','Rack','2' UNION ALL

  SELECT '8520','2009-06-24','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '8521','2009-06-24','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '8523','2009-06-24','199','3972','Jamaican Salad','9' UNION ALL

  SELECT '8524','2009-06-24','200','3973','Greek Salad','8' UNION ALL

  SELECT '8526','2009-06-24','182','2025','Chicken Caesar Salad','6' UNION ALL

  SELECT '8527','2009-06-24','201','4263','Lg Brewhouse/Chicken','5' UNION ALL

  SELECT '8528','2009-06-24','183','2027','Mill Salad/ Brisket','4' UNION ALL

  SELECT '8530','2009-06-24','185','2031','Mill Salad/ Chicken','3' UNION ALL

  SELECT '8531','2009-06-24','202','4264','Lg Brewhouse/Tuna','2' UNION ALL

  SELECT '8532','2009-06-24','197','3631','Tuna Caesar Salad','2' UNION ALL

  SELECT '8548','2009-06-24','1421','4662','Red Bull','8' UNION ALL

  SELECT '8643','2009-06-24','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '8686','2009-06-24','143','2035','Kid Fish','3' UNION ALL

  SELECT '8805','2009-06-25','242','3732','Brisket Sandwich','26' UNION ALL

  SELECT '8807','2009-06-25','236','3468','Grilled Prime Sandwich','18' UNION ALL

  SELECT '8808','2009-06-25','226','2097','Hot Beef Sand','20' UNION ALL

  SELECT '8809','2009-06-25','230','2884','Fish Sandwich','16' UNION ALL

  SELECT '8810','2009-06-25','224','2094','Caribbean Chix Sand','16' UNION ALL

  SELECT '8811','2009-06-25','223','2091','Tuna Sandwich','13' UNION ALL

  SELECT '8813','2009-06-25','221','2086','BBQ Chx Sandwich','10' UNION ALL

  SELECT '8814','2009-06-25','227','2098','Brat Sand','9' UNION ALL

  SELECT '8816','2009-06-25','237','3469','Pork Sandwich','8' UNION ALL

  SELECT '8829','2009-06-25','26','2713','Boiled Shrimp App','14' UNION ALL

  SELECT '8833','2009-06-25','35','3964','Calamari','6' UNION ALL

  SELECT '8834','2009-06-25','29','3957','Shrimp Poppers','7' UNION ALL

  SELECT '8838','2009-06-25','83','2039','Ribeye','8' UNION ALL

  SELECT '8839','2009-06-25','86','2044','Mahi-Mahi','5' UNION ALL

  SELECT '8840','2009-06-25','88','2048','Caribbean Chicken','5' UNION ALL

  SELECT '8841','2009-06-25','81','2036','Prime Rib 8oz.','4' UNION ALL

  SELECT '8842','2009-06-25','82','2037','Smoked Reg Prime','3' UNION ALL

  SELECT '8843','2009-06-25','108','4097','Half Rack/Brewhouse','3' UNION ALL

  SELECT '8844','2009-06-25','84','2040','Smoked Brew Prime','2' UNION ALL

  SELECT '8845','2009-06-25','90','2053','Salmon Fillet','2' UNION ALL

  SELECT '8846','2009-06-25','113','4102','Fish & Chips/ Caesar','2' UNION ALL

  SELECT '8849','2009-06-25','85','2041','Filet','1' UNION ALL

  SELECT '8851','2009-06-25','116','4106','BBQ Chicken/ Brewhouse','1' UNION ALL

  SELECT '8852','2009-06-25','112','4101','Fish & Chips/Salad','1' UNION ALL

  SELECT '8853','2009-06-25','118','4109','Country Style/Brewhouse','1' UNION ALL

  SELECT '8854','2009-06-25','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '8869','2009-06-25','199','3972','Jamaican Salad','11' UNION ALL

  SELECT '8871','2009-06-25','200','3973','Greek Salad','9' UNION ALL

  SELECT '8872','2009-06-25','185','2031','Mill Salad/ Chicken','6' UNION ALL

  SELECT '8873','2009-06-25','183','2027','Mill Salad/ Brisket','5' UNION ALL

  SELECT '8874','2009-06-25','201','4263','Lg Brewhouse/Chicken','5' UNION ALL

  SELECT '8875','2009-06-25','182','2025','Chicken Caesar Salad','4' UNION ALL

  SELECT '8878','2009-06-25','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '8881','2009-06-25','133','3507','Fish & Chips','14' UNION ALL

  SELECT '8882','2009-06-25','132','3501','Half Rack','9' UNION ALL

  SELECT '8883','2009-06-25','129','2047','Sausage Platter','6' UNION ALL

  SELECT '8884','2009-06-25','135','4105','BBQ Chicken Breast','5' UNION ALL

  SELECT '8885','2009-06-25','134','3934','Rack','2' UNION ALL

  SELECT '8886','2009-06-25','131','3498','Shrimp & Chips','3' UNION ALL

  SELECT '8887','2009-06-25','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '8899','2009-06-25','1421','4662','Red Bull','6' UNION ALL

  SELECT '8981','2009-06-25','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '9039','2009-06-25','143','2035','Kid Fish','1' UNION ALL

  SELECT '9151','2009-06-26','242','3732','Brisket Sandwich','51' UNION ALL

  SELECT '9152','2009-06-26','230','2884','Fish Sandwich','29' UNION ALL

  SELECT '9153','2009-06-26','236','3468','Grilled Prime Sandwich','24' UNION ALL

  SELECT '9154','2009-06-26','224','2094','Caribbean Chix Sand','30' UNION ALL

  SELECT '9155','2009-06-26','221','2086','BBQ Chx Sandwich','28' UNION ALL

  SELECT '9157','2009-06-26','226','2097','Hot Beef Sand','23' UNION ALL

  SELECT '9160','2009-06-26','223','2091','Tuna Sandwich','19' UNION ALL

  SELECT '9161','2009-06-26','237','3469','Pork Sandwich','19' UNION ALL

  SELECT '9164','2009-06-26','227','2098','Brat Sand','10' UNION ALL

  SELECT '9175','2009-06-26','26','2713','Boiled Shrimp App','13' UNION ALL

  SELECT '9176','2009-06-26','35','3964','Calamari','10' UNION ALL

  SELECT '9178','2009-06-26','29','3957','Shrimp Poppers','6' UNION ALL

  SELECT '9184','2009-06-26','133','3507','Fish & Chips','20' UNION ALL

  SELECT '9185','2009-06-26','129','2047','Sausage Platter','12' UNION ALL

  SELECT '9186','2009-06-26','131','3498','Shrimp & Chips','11' UNION ALL

  SELECT '9187','2009-06-26','135','4105','BBQ Chicken Breast','9' UNION ALL

  SELECT '9188','2009-06-26','132','3501','Half Rack','7' UNION ALL

  SELECT '9189','2009-06-26','136','4108','Country Style Ribs','6' UNION ALL

  SELECT '9190','2009-06-26','137','4335','Fish & Chips/ SUB','3' UNION ALL

  SELECT '9191','2009-06-26','134','3934','Rack','1' UNION ALL

  SELECT '9192','2009-06-26','130','2052','Smokehouse Combo','1' UNION ALL

  SELECT '9194','2009-06-26','89','2049','Pork Medallions','11' UNION ALL

  SELECT '9195','2009-06-26','82','2037','Smoked Reg Prime','8' UNION ALL

  SELECT '9196','2009-06-26','90','2053','Salmon Fillet','4' UNION ALL

  SELECT '9197','2009-06-26','84','2040','Smoked Brew Prime','3' UNION ALL

  SELECT '9198','2009-06-26','83','2039','Ribeye','3' UNION ALL

  SELECT '9199','2009-06-26','81','2036','Prime Rib 8oz.','3' UNION ALL

  SELECT '9200','2009-06-26','114','4103','Shrimp & Salad','3' UNION ALL

  SELECT '9201','2009-06-26','88','2048','Caribbean Chicken','3' UNION ALL

  SELECT '9202','2009-06-26','85','2041','Filet','2' UNION ALL

  SELECT '9203','2009-06-26','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '9204','2009-06-26','118','4109','Country Style/Brewhouse','2' UNION ALL

  SELECT '9205','2009-06-26','126','4341','Shrimp & Chips SUB','2' UNION ALL

  SELECT '9209','2009-06-26','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '9210','2009-06-26','113','4102','Fish & Chips/ Caesar','1' UNION ALL

  SELECT '9268','2009-06-26','200','3973','Greek Salad','19' UNION ALL

  SELECT '9270','2009-06-26','183','2027','Mill Salad/ Brisket','10' UNION ALL

  SELECT '9271','2009-06-26','199','3972','Jamaican Salad','9' UNION ALL

  SELECT '9272','2009-06-26','185','2031','Mill Salad/ Chicken','4' UNION ALL

  SELECT '9274','2009-06-26','182','2025','Chicken Caesar Salad','3' UNION ALL

  SELECT '9278','2009-06-26','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '9299','2009-06-26','1421','4662','Red Bull','2' UNION ALL

  SELECT '9418','2009-06-26','143','2035','Kid Fish','1' UNION ALL

  SELECT '9563','2009-06-27','224','2094','Caribbean Chix Sand','36' UNION ALL

  SELECT '9564','2009-06-27','236','3468','Grilled Prime Sandwich','28' UNION ALL

  SELECT '9565','2009-06-27','242','3732','Brisket Sandwich','25' UNION ALL

  SELECT '9566','2009-06-27','221','2086','BBQ Chx Sandwich','20' UNION ALL

  SELECT '9568','2009-06-27','226','2097','Hot Beef Sand','16' UNION ALL

  SELECT '9569','2009-06-27','223','2091','Tuna Sandwich','16' UNION ALL

  SELECT '9570','2009-06-27','237','3469','Pork Sandwich','14' UNION ALL

  SELECT '9572','2009-06-27','230','2884','Fish Sandwich','9' UNION ALL

  SELECT '9574','2009-06-27','227','2098','Brat Sand','7' UNION ALL

  SELECT '9585','2009-06-27','35','3964','Calamari','14' UNION ALL

  SELECT '9588','2009-06-27','29','3957','Shrimp Poppers','9' UNION ALL

  SELECT '9589','2009-06-27','26','2713','Boiled Shrimp App','7' UNION ALL

  SELECT '9592','2009-06-27','133','3507','Fish & Chips','33' UNION ALL

  SELECT '9593','2009-06-27','131','3498','Shrimp & Chips','23' UNION ALL

  SELECT '9594','2009-06-27','135','4105','BBQ Chicken Breast','10' UNION ALL

  SELECT '9595','2009-06-27','132','3501','Half Rack','9' UNION ALL

  SELECT '9596','2009-06-27','129','2047','Sausage Platter','7' UNION ALL

  SELECT '9597','2009-06-27','130','2052','Smokehouse Combo','4' UNION ALL

  SELECT '9598','2009-06-27','137','4335','Fish & Chips/ SUB','3' UNION ALL

  SELECT '9599','2009-06-27','136','4108','Country Style Ribs','1' UNION ALL

  SELECT '9601','2009-06-27','82','2037','Smoked Reg Prime','9' UNION ALL

  SELECT '9602','2009-06-27','86','2044','Mahi-Mahi','7' UNION ALL

  SELECT '9603','2009-06-27','90','2053','Salmon Fillet','7' UNION ALL

  SELECT '9604','2009-06-27','84','2040','Smoked Brew Prime','5' UNION ALL

  SELECT '9605','2009-06-27','85','2041','Filet','5' UNION ALL

  SELECT '9606','2009-06-27','88','2048','Caribbean Chicken','5' UNION ALL

  SELECT '9607','2009-06-27','81','2036','Prime Rib 8oz.','4' UNION ALL

  SELECT '9608','2009-06-27','89','2049','Pork Medallions','4' UNION ALL

  SELECT '9610','2009-06-27','83','2039','Ribeye','2' UNION ALL

  SELECT '9611','2009-06-27','108','4097','Half Rack/Brewhouse','2' UNION ALL

  SELECT '9613','2009-06-27','126','4341','Shrimp & Chips SUB','2' UNION ALL

  SELECT '9614','2009-06-27','109','4098','Half Rack/ Caesar','1' UNION ALL

  SELECT '9615','2009-06-27','115','4104','Shrimp & Caesar','1' UNION ALL

  SELECT '9616','2009-06-27','114','4103','Shrimp & Salad','1' UNION ALL

  SELECT '9617','2009-06-27','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '9676','2009-06-27','183','2027','Mill Salad/ Brisket','9' UNION ALL

  SELECT '9677','2009-06-27','185','2031','Mill Salad/ Chicken','8' UNION ALL

  SELECT '9678','2009-06-27','200','3973','Greek Salad','9' UNION ALL

  SELECT '9679','2009-06-27','182','2025','Chicken Caesar Salad','8' UNION ALL

  SELECT '9680','2009-06-27','199','3972','Jamaican Salad','6' UNION ALL

  SELECT '9682','2009-06-27','201','4263','Lg Brewhouse/Chicken','4' UNION ALL

  SELECT '9685','2009-06-27','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '9706','2009-06-27','1421','4662','Red Bull','17' UNION ALL

  SELECT '9741','2009-06-27','143','2035','Kid Fish','10' UNION ALL

  SELECT '9773','2009-06-27','395','2565','+ Chicken 5 oz 4.25','1' UNION ALL

  SELECT '9775','2009-06-27','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '9947','2009-06-28','236','3468','Grilled Prime Sandwich','23' UNION ALL

  SELECT '9948','2009-06-28','230','2884','Fish Sandwich','24' UNION ALL

  SELECT '9949','2009-06-28','226','2097','Hot Beef Sand','22' UNION ALL

  SELECT '9950','2009-06-28','242','3732','Brisket Sandwich','19' UNION ALL

  SELECT '9951','2009-06-28','224','2094','Caribbean Chix Sand','16' UNION ALL

  SELECT '9952','2009-06-28','221','2086','BBQ Chx Sandwich','14' UNION ALL

  SELECT '9954','2009-06-28','237','3469','Pork Sandwich','12' UNION ALL

  SELECT '9955','2009-06-28','223','2091','Tuna Sandwich','8' UNION ALL

  SELECT '9958','2009-06-28','227','2098','Brat Sand','7' UNION ALL

  SELECT '9984','2009-06-28','26','2713','Boiled Shrimp App','5' UNION ALL

  SELECT '9985','2009-06-28','35','3964','Calamari','5' UNION ALL

  SELECT '9988','2009-06-28','29','3957','Shrimp Poppers','2' UNION ALL

  SELECT '9992','2009-06-28','133','3507','Fish & Chips','23' UNION ALL

  SELECT '9993','2009-06-28','131','3498','Shrimp & Chips','12' UNION ALL

  SELECT '9994','2009-06-28','132','3501','Half Rack','10' UNION ALL

  SELECT '9995','2009-06-28','129','2047','Sausage Platter','6' UNION ALL

  SELECT '9996','2009-06-28','130','2052','Smokehouse Combo','3' UNION ALL

  SELECT '9997','2009-06-28','135','4105','BBQ Chicken Breast','4' UNION ALL

  SELECT '9998','2009-06-28','136','4108','Country Style Ribs','3' UNION ALL

  SELECT '10012','2009-06-28','1421','4662','Red Bull','1' UNION ALL

  SELECT '10021','2009-06-28','199','3972','Jamaican Salad','11' UNION ALL

  SELECT '10023','2009-06-28','200','3973','Greek Salad','9' UNION ALL

  SELECT '10024','2009-06-28','185','2031','Mill Salad/ Chicken','3' UNION ALL

  SELECT '10026','2009-06-28','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '10027','2009-06-28','201','4263','Lg Brewhouse/Chicken','2' UNION ALL

  SELECT '10028','2009-06-28','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '10029','2009-06-28','182','2025','Chicken Caesar Salad','1' UNION ALL

  SELECT '10038','2009-06-28','90','2053','Salmon Fillet','5' UNION ALL

  SELECT '10039','2009-06-28','86','2044','Mahi-Mahi','2' UNION ALL

  SELECT '10040','2009-06-28','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '10041','2009-06-28','88','2048','Caribbean Chicken','2' UNION ALL

  SELECT '10043','2009-06-28','84','2040','Smoked Brew Prime','1' UNION ALL

  SELECT '10044','2009-06-28','82','2037','Smoked Reg Prime','1' UNION ALL

  SELECT '10045','2009-06-28','114','4103','Shrimp & Salad','1' UNION ALL

  SELECT '10050','2009-06-28','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '10075','2009-06-28','143','2035','Kid Fish','10' UNION ALL

  SELECT '10116','2009-06-28','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '10121','2009-06-28','590','4079','+ Brisket 1.25','1' UNION ALL

  SELECT '10258','2009-06-29','242','3732','Brisket Sandwich','21' UNION ALL

  SELECT '10260','2009-06-29','236','3468','Grilled Prime Sandwich','15' UNION ALL

  SELECT '10261','2009-06-29','224','2094','Caribbean Chix Sand','17' UNION ALL

  SELECT '10262','2009-06-29','226','2097','Hot Beef Sand','12' UNION ALL

  SELECT '10264','2009-06-29','230','2884','Fish Sandwich','9' UNION ALL

  SELECT '10265','2009-06-29','221','2086','BBQ Chx Sandwich','10' UNION ALL

  SELECT '10266','2009-06-29','223','2091','Tuna Sandwich','8' UNION ALL

  SELECT '10269','2009-06-29','227','2098','Brat Sand','7' UNION ALL

  SELECT '10270','2009-06-29','237','3469','Pork Sandwich','7' UNION ALL

  SELECT '10283','2009-06-29','132','3501','Half Rack','11' UNION ALL

  SELECT '10284','2009-06-29','131','3498','Shrimp & Chips','9' UNION ALL

  SELECT '10285','2009-06-29','133','3507','Fish & Chips','8' UNION ALL

  SELECT '10286','2009-06-29','129','2047','Sausage Platter','8' UNION ALL

  SELECT '10287','2009-06-29','135','4105','BBQ Chicken Breast','7' UNION ALL

  SELECT '10288','2009-06-29','136','4108','Country Style Ribs','4' UNION ALL

  SELECT '10289','2009-06-29','134','3934','Rack','2' UNION ALL

  SELECT '10290','2009-06-29','130','2052','Smokehouse Combo','2' UNION ALL

  SELECT '10291','2009-06-29','137','4335','Fish & Chips/ SUB','2' UNION ALL

  SELECT '10294','2009-06-29','35','3964','Calamari','13' UNION ALL

  SELECT '10302','2009-06-29','26','2713','Boiled Shrimp App','7' UNION ALL

  SELECT '10306','2009-06-29','29','3957','Shrimp Poppers','4' UNION ALL

  SELECT '10309','2009-06-29','82','2037','Smoked Reg Prime','4' UNION ALL

  SELECT '10310','2009-06-29','83','2039','Ribeye','4' UNION ALL

  SELECT '10311','2009-06-29','81','2036','Prime Rib 8oz.','4' UNION ALL

  SELECT '10312','2009-06-29','84','2040','Smoked Brew Prime','3' UNION ALL

  SELECT '10313','2009-06-29','85','2041','Filet','3' UNION ALL

  SELECT '10314','2009-06-29','90','2053','Salmon Fillet','3' UNION ALL

  SELECT '10315','2009-06-29','116','4106','BBQ Chicken/ Brewhouse','3' UNION ALL

  SELECT '10316','2009-06-29','89','2049','Pork Medallions','3' UNION ALL

  SELECT '10318','2009-06-29','112','4101','Fish & Chips/Salad','2' UNION ALL

  SELECT '10319','2009-06-29','88','2048','Caribbean Chicken','2' UNION ALL

  SELECT '10321','2009-06-29','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '10323','2009-06-29','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '10362','2009-06-29','199','3972','Jamaican Salad','14' UNION ALL

  SELECT '10363','2009-06-29','201','4263','Lg Brewhouse/Chicken','10' UNION ALL

  SELECT '10365','2009-06-29','182','2025','Chicken Caesar Salad','6' UNION ALL

  SELECT '10367','2009-06-29','200','3973','Greek Salad','3' UNION ALL

  SELECT '10368','2009-06-29','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '10370','2009-06-29','202','4264','Lg Brewhouse/Tuna','1' UNION ALL

  SELECT '10371','2009-06-29','197','3631','Tuna Caesar Salad','1' UNION ALL

  SELECT '10381','2009-06-29','1421','4662','Red Bull','3' UNION ALL

  SELECT '10451','2009-06-29','410','2596','+ Chick Breast $2.99','1' UNION ALL

  SELECT '10608','2009-06-30','224','2094','Caribbean Chix Sand','19' UNION ALL

  SELECT '10609','2009-06-30','242','3732','Brisket Sandwich','15' UNION ALL

  SELECT '10610','2009-06-30','230','2884','Fish Sandwich','11' UNION ALL

  SELECT '10611','2009-06-30','226','2097','Hot Beef Sand','11' UNION ALL

  SELECT '10612','2009-06-30','223','2091','Tuna Sandwich','9' UNION ALL

  SELECT '10613','2009-06-30','236','3468','Grilled Prime Sandwich','8' UNION ALL

  SELECT '10614','2009-06-30','221','2086','BBQ Chx Sandwich','9' UNION ALL

  SELECT '10616','2009-06-30','237','3469','Pork Sandwich','6' UNION ALL

  SELECT '10619','2009-06-30','227','2098','Brat Sand','4' UNION ALL

  SELECT '10622','2009-06-30','81','2036','Prime Rib 8oz.','7' UNION ALL

  SELECT '10623','2009-06-30','89','2049','Pork Medallions','7' UNION ALL

  SELECT '10624','2009-06-30','84','2040','Smoked Brew Prime','4' UNION ALL

  SELECT '10625','2009-06-30','85','2041','Filet','4' UNION ALL

  SELECT '10626','2009-06-30','88','2048','Caribbean Chicken','5' UNION ALL

  SELECT '10627','2009-06-30','82','2037','Smoked Reg Prime','4' UNION ALL

  SELECT '10628','2009-06-30','90','2053','Salmon Fillet','3' UNION ALL

  SELECT '10629','2009-06-30','112','4101','Fish & Chips/Salad','3' UNION ALL

  SELECT '10632','2009-06-30','83','2039','Ribeye','1' UNION ALL

  SELECT '10633','2009-06-30','86','2044','Mahi-Mahi','1' UNION ALL

  SELECT '10634','2009-06-30','108','4097','Half Rack/Brewhouse','1' UNION ALL

  SELECT '10636','2009-06-30','122','4336','Fish & Chips/ Salad SUB','1' UNION ALL

  SELECT '10637','2009-06-30','106','4095','Sausage Platter/ Brewhouse','1' UNION ALL

  SELECT '10640','2009-06-30','126','4341','Shrimp & Chips SUB','1' UNION ALL

  SELECT '10650','2009-06-30','26','2713','Boiled Shrimp App','7' UNION ALL

  SELECT '10652','2009-06-30','35','3964','Calamari','8' UNION ALL

  SELECT '10655','2009-06-30','29','3957','Shrimp Poppers','6' UNION ALL

  SELECT '10660','2009-06-30','133','3507','Fish & Chips','10' UNION ALL

  SELECT '10661','2009-06-30','129','2047','Sausage Platter','10' UNION ALL

  SELECT '10662','2009-06-30','132','3501','Half Rack','4' UNION ALL

  SELECT '10663','2009-06-30','131','3498','Shrimp & Chips','4' UNION ALL

  SELECT '10664','2009-06-30','136','4108','Country Style Ribs','4' UNION ALL

  SELECT '10665','2009-06-30','134','3934','Rack','2' UNION ALL

  SELECT '10666','2009-06-30','135','4105','BBQ Chicken Breast','3' UNION ALL

  SELECT '10667','2009-06-30','137','4335','Fish & Chips/ SUB','1' UNION ALL

  SELECT '10696','2009-06-30','199','3972','Jamaican Salad','14' UNION ALL

  SELECT '10698','2009-06-30','200','3973','Greek Salad','6' UNION ALL

  SELECT '10699','2009-06-30','185','2031','Mill Salad/ Chicken','4' UNION ALL

  SELECT '10700','2009-06-30','183','2027','Mill Salad/ Brisket','2' UNION ALL

  SELECT '10701','2009-06-30','201','4263','Lg Brewhouse/Chicken','2' UNION ALL

  SELECT '10702','2009-06-30','182','2025','Chicken Caesar Salad','1' UNION ALL

  SELECT '10823','2009-06-30','143','2035','Kid Fish','3'

  --===== Set the identity insert back to normal

  SET IDENTITY_INSERT SalesQty OFF

  I almost forgot a couple of tables "MenuCategory" and "UOM":

  IF OBJECT_ID('TempDB..MenuCategory','U') IS NOT NULL

  DROP TABLE MenuCategory

  --===== Create the test table with

  CREATE TABLE [dbo].[MenuCategory](

  [MenuCat_ID] [int] IDENTITY(1,1) NOT NULL,

  [CatName] [varchar](50) NOT NULL,

  [CatType] [varchar](5) NULL,

  CONSTRAINT [PK_MenuCategory] PRIMARY KEY CLUSTERED

  (

  [MenuCat_ID] ASC

  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

  )

  --===== Setup any special required conditions especially where dates are concerned

  --===== All Inserts into the IDENTITY column

  SET IDENTITY_INSERT MenuCategory ON

  --===== Insert the test data into the test table

  INSERT INTO MenuCategory (MenuCat_ID, CatName, CatType)

  SELECT '1','Entree','Food' UNION ALL

  SELECT '2','Appetizer','Food' UNION ALL

  SELECT '3','Salad','Food' UNION ALL

  SELECT '4','Combo','Food' UNION ALL

  SELECT '5','Sandwich','Food' UNION ALL

  SELECT '6','Burger','Food' UNION ALL

  SELECT '8','Specialties','Food' UNION ALL

  SELECT '9','Soup','Food' UNION ALL

  SELECT '11','Kid','Food' UNION ALL

  SELECT '12','Dessert','Food' UNION ALL

  SELECT '13','Extra/Side','Food' UNION ALL

  SELECT '14','FoodModifier','Food' UNION ALL

  SELECT '15','OldMenu','Food' UNION ALL

  SELECT '16','OldMenuApp','Food' UNION ALL

  SELECT '17','NABev','Food' UNION ALL

  SELECT '18','BeerDraft','Liq' UNION ALL

  SELECT '19','BeerBottle','Liq' UNION ALL

  SELECT '20','WineGlass','Liq' UNION ALL

  SELECT '21','WineBottle','Liq' UNION ALL

  SELECT '22','Liquor','Liq' UNION ALL

  SELECT '23','PrepItem','Prep' UNION ALL

  SELECT '24','Special','Food' UNION ALL

  SELECT '25','Retail','Retl' UNION ALL

  SELECT '26','Pizza','Food' UNION ALL

  SELECT '28','WholesaleBeer','Liq' UNION ALL

  SELECT '29','RetailBeer','Liq' UNION ALL

  SELECT '30','WholesaleN/A','Misc' UNION ALL

  SELECT '31','Misc','Misc'

  --===== Set the identity insert back to normal

  SET IDENTITY_INSERT MenuCategory OFF

  IF OBJECT_ID('TempDB..UOM','U') IS NOT NULL

  DROP TABLE UOM

  --===== Create the test table with

  CREATE TABLE [dbo].[UOM](

  [UOM_ID] [int] IDENTITY(1,1) NOT NULL,

  [UOM_Name] [varchar](50) NOT NULL,

  CONSTRAINT [PK_UOM] PRIMARY KEY CLUSTERED

  (

  [UOM_ID] ASC

  )

  --===== Setup any special required conditions especially where dates are concerned

  --===== All Inserts into the IDENTITY column

  SET IDENTITY_INSERT UOM ON

  --===== Insert the test data into the test table

  INSERT INTO UOM (UOM_ID, UOMName)

  SELECT '1','#10 CAN' UNION ALL

  SELECT '2','#2.5 CAN' UNION ALL

  SELECT '3','DZ' UNION ALL

  SELECT '4','EA' UNION ALL

  SELECT '5','GAL' UNION ALL

  SELECT '6','GR' UNION ALL

  SELECT '7','KG' UNION ALL

  SELECT '8','LB' UNION ALL

  SELECT '9','OZ' UNION ALL

  SELECT '10','QT' UNION ALL

  SELECT '11','Slice' UNION ALL

  SELECT '12','CT' UNION ALL

  SELECT '13','Case' UNION ALL

  SELECT '14','OZ(Liq)' UNION ALL

  SELECT '15','LTR'

  --===== Set the identity insert back to normal

  SET IDENTITY_INSERT UOM OFF

  My first stab at this yielded the expected results:

  SELECT sq.Date,

  sq.Description,

  sq.Qty

  FROM SalesQty sq

  Left Join MenuItem mi

  On sq.Description = mi.Description

  Left Join MenuCategory mc

  On mi.MenuCat_ID = mc.MenuCat_ID

  WHERE sq.Date BETWEEN '20090601' AND '20090630'

  AND (( @@datefirst + datepart(weekday, sq.Date) -2 ) %7 + 1 ) = 1

  AND mc.CatType = 'Food'

  AND sq.Description = 'Ribeye'

  Result:

  DateDescriptionQty

  2009-06-01Ribeye13

  2009-06-08Ribeye6

  2009-06-15Ribeye1

  2009-06-22Ribeye5

  2009-06-29Ribeye4

  Now, I need retrieve all items, and average all days(In this case Monday). I tried:

  SELECT ii.Description, AVG(sq.Qty) AS Monday,

  (Select u.UOM_Name

  From UOM u

  Where u.UOM_ID = ii.InvUnit) AS UOM

  FROM Sales_Qty sq

  LEFT JOIN InventoryItem_MenuItem im

  ON sq.MenuItem_ID = im.MenuItem_ID

  LEFT JOIN InventoryItem ii

  ON im.InvItem_ID = ii.InvItem_ID

  WHERE sq.Date BETWEEN '20090601' AND '20090630'

  AND (( @@datefirst + datepart(weekday, sq.Date) -2 ) %7 + 1 ) = 1

  AND ii.Active = 1

  GROUP BY ii.Description, ii.Level1_ID, ii.Level2_ID, ii.Level3_ID, ii.InvUnit

  ORDER BY ii.Level1_ID, ii.Level2_ID, ii.Level3_ID, ii.Description

  At first glance this seemed to work, but upon further investigation, it was not handling the many-to-many relationships:

  Brisket9EA

  Filet4EA

  Hot Beef Portion11EA

  Prime Rib7LB

  Ribeye5EA

  Country Rib3EA

  Pork Tenderloin6EA

  Rack3EA

  Bratwurst4EA

  Knockwurst4EA

  Weisswurst4EA

  Airline Chicken2EA

  Chicken 10 Oz.5EA

  Chicken 5 Oz.6EA

  Cod5EA

  Mahi 10 Oz.3EA

  Salmon5EA

  Tuna3EA

  Boiled Shrimp13LB

  Calamari12EA

  P&D Shrimp4LB

  For instance; 'Chicken 5 Oz.' should return 47 (235 sold over 5 Mondays)

  Where would you, the experts, suggest I turn next?

  Was this post long enough? Please don't tell me if I missed anything, just ignore me and I'll go away.:-)

  Thanks again,

  Mike

• Jeff Moden

  SSC Guru

  Points: 1004641

  More actions

  May 30, 2010 at 8:32 pm

  #1174375

  I just got done fixing a bunch of errors (most missing parens on table creations) in the data scripts. And, because the post is so long (I recommend attaching files next time), doing anything on this thread has become dog slow as the formatter code behind the scenes struggles with all the inserts.

  I finally have all the scripts copied and running. I'm starting to take a look at this now but it is getting late. I might not be able to finish tonight.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Jeff Moden

  SSC Guru

  Points: 1004641

  More actions

  May 30, 2010 at 9:23 pm

  #1174379

  I believe your only problem is that you were taking the average of the wrong thing...

  SELECT ii.Description, AVG(sq.Qty*ii.Amount) AS MondayAvg,

  (Select u.UOM_Name

  From UOM u

  Where u.UOM_ID = ii.InvUnit) AS UOM

  FROM SalesQty sq

  LEFT JOIN InventoryItem_MenuItem im

  ON sq.MenuItem_ID = im.MenuItem_ID

  LEFT JOIN InventoryItem ii

  ON im.InvItem_ID = ii.InvItem_ID

  WHERE sq.Date BETWEEN '20090601' AND '20090630'

  AND (( @@datefirst + datepart(weekday, sq.Date) -2 ) %7 + 1 ) = 1

  AND ii.Active = 1

  GROUP BY ii.Description,ii.InvUnit

  ORDER BY ii.Description

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• spike62

  Say Hey Kid

  Points: 706

  More actions

  May 31, 2010 at 1:48 am

  #1174418

  Hi Jeff,

  One problem: the results on items with One-To-One relationships are spot on, but the results with One-To-Many relationships are being averaged on the total number of results rather than the number of Mondays. For example:

  Chicken 5 Oz.- 235 total sold over 5 Mondays averages to 47.

  Using "AVG(sq.Qty*ii.Amount) AS MondayAvg" results in 6.911764, or 235/34, 34 being the total number of results of daily sales of eight different menu items containing 5 Oz. chickens:

  6/1/2009Chicken Caesar Salad6

  6/8/2009Chicken Caesar Salad3

  6/15/2009 Chicken Caesar Salad5

  6/22/2009 Chicken Caesar Salad4

  6/29/2009 Chicken Caesar Salad6

  6/1/2009Lg Brewhouse/Chicken4

  6/8/2009Lg Brewhouse/Chicken1

  6/15/2009 Lg Brewhouse/Chicken1

  6/22/2009 Lg Brewhouse/Chicken5

  6/29/2009 Lg Brewhouse/Chicken10

  6/1/2009Mill Salad/ Chicken 3

  6/8/2009Mill Salad/ Chicken 4

  6/15/2009 Mill Salad/ Chicken4

  6/22/2009 Mill Salad/ Chicken7

  6/1/2009BBQ Chx Sandwich 12

  6/8/2009BBQ Chx Sandwich 8

  6/15/2009 BBQ Chx Sandwich10

  6/22/2009 BBQ Chx Sandwich14

  6/29/2009 BBQ Chx Sandwich10

  6/1/2009Caribbean Chix Sand16

  6/8/2009Caribbean Chix Sand12

  6/15/2009 Caribbean Chix Sand18

  6/22/2009 Caribbean Chix Sand17

  6/29/2009 Caribbean Chix Sand17

  6/1/2009+ Chick Breast $2.992

  6/8/2009+ Chick Breast $2.991

  6/15/2009 + Chick Breast $2.991

  6/22/2009 + Chick Breast $2.991

  6/29/2009 + Chick Breast $2.991

  6/1/2009BBQ Chicken Breast5

  6/8/2009BBQ Chicken Breast8

  6/15/2009 BBQ Chicken Breast7

  6/22/2009 BBQ Chicken Breast5

  6/29/2009 BBQ Chicken Breast7

  ___________________________ __

  34 results = 235

  Now, using this statement yields the correct totals for all items, I would just need to average.

  SELECT ii.Description,

  SUM(sq.Qty * im.Amount) AS Monday, --==Note I changed to table im.

  (Select u.UOM_Name

  From UOM u

  WHERE u.UOM_ID = ii.InvUnit) AS UOM

  FROM SalesQty sq

  LEFT JOIN InventoryItem_MenuItem im

  ON sq.MenuItem_ID = im.MenuItem_ID

  LEFT JOIN InventoryItem ii

  ON im.InvItem_ID = ii.InvItem_ID

  WHERE sq.Date BETWEEN '20090601' AND '20090630'

  AND (( @@datefirst + datepart(weekday, sq.Date) -2 ) %7 + 1 ) = 1

  AND ii.Active = 1

  GROUP BY ii.Description, ii.InvUnit

  ORDER BY ii.Description

  Any direct solutions you can think of? One thought I had; Would a possible solution be finding the number of Mondays in date range and assign that to a variable, @Days, and appending it to "SUM(sq.Qty * im.Amount) /@Days" ?

  Thanks for all your help so far,

  Mike

  p.s. For future reference, please let me know what sort of mistakes I made on CREATE statements. I figured letting SSMS do the work and copying it would be the proper way.

• spike62

  Say Hey Kid

  Points: 706

  More actions

  May 31, 2010 at 9:28 am

  #1174531

  Also...

  Since I was up at an ungodly hour anyway, I went ahead and added a calendar table to my DB(from a script on this site), used it to set a variable as the number of days in date range, and performed SELECT as I suggested above. Works like a charm(so far as I can tell ):

  declare @startdate datetime

  declare @enddate datetime

  declare @Days Int

  set @startdate = '20090601'

  set @enddate = '20090630'

  set @Days =

  (SELECT COUNT(*)

  FROM dbo.date_calendar

  WHERE calendar_date >= @startdate

  and calendar_date <= @enddate

  and day_Name = 'Monday') --==Calendar script has different start day, but also had day as alpha. Need to fix.

  --Select @Days

  SELECT ii.Description,

  SUM(sq.Qty * im.Amount)/@Days AS Monday,

  (Select u.UOM_Name

  From UOM u

  WHERE u.UOM_ID = ii.InvUnit) AS UOM

  FROM Sales_Qty sq

  LEFT JOIN InventoryItem_MenuItem im

  ON sq.MenuItem_ID = im.MenuItem_ID

  LEFT JOIN InventoryItem ii

  ON im.InvItem_ID = ii.InvItem_ID

  WHERE sq.Date BETWEEN '20090601' AND '20090630'

  AND (( @@datefirst + datepart(weekday, sq.Date) -2 ) %7 + 1 ) = 1

  AND ii.Active = 1

  GROUP BY ii.Description, ii.Level1_ID, ii.Level2_ID, ii.Level3_ID, ii.InvUnit

  ORDER BY ii.Level1_ID, ii.Level2_ID, ii.Level3_ID

  I still need to know if it is possible to create(relatively simply) a view of all seven days of the week.

  Thanks,

  Mike

• Jeff Moden

  SSC Guru

  Points: 1004641

  More actions

  May 31, 2010 at 9:43 am

  #1174536

  spike62 (5/31/2010)

  ---

  Also...

  Since I was up at an ungodly hour anyway, I went ahead and added a calendar table to my DB(from a script on this site), used it to set a variable as the number of days in date range, and performed SELECT as I suggested above. Works like a charm(so far as I can tell ):

  Heh... now you know where I thought the Tally table was going to come into play.

  I still need to know if it is possible to create(relatively simply) a view of all seven days of the week.

  Ah... got it. I was concentrating on just making your current code work. I'll take a look. If you beat me to it, please make sure you post so I don't spend more time on it. Thanks, Mike.

  P.S. Are you absolutely sure that it needs to be a view? That requirement by itself may knock out a couple of "easy" methods.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• spike62

  Say Hey Kid

  Points: 706

  More actions

  May 31, 2010 at 2:27 pm

  #1174589

  Hi Jeff,

  I just got home from work so haven't had any time to mess with it. I don't know if "View" is the word I'm actually looking for. What I mean is that I'll be calling this from the application and it would be nice if I could fill the DataGridView in one fell swoop(Monday, Tuesday, Wednesday, etc.), As opposed to creating and assigning datasources to each individual column.

  I do truly appreciate your help, and will give you a heads up should I have another epiphany.

  Mike