Proc Subway WeeklySummary Save Batch

Purpose
This procedure inserts a new record or updates an existing record in the table WeeklySummary. It was made into its own stored procedure so it could be called when creating Invoices, Cash Receipts, or Beginning Balances

Method Signature
[dbo].[proc_Subway_WeeklySummary_Save_Batch] @WeeklySummaryXML XML ,  @WeeklySummaryTypeDescription VARCHAR(50) ,  @UserDepartmentID INTEGER ,  @UserJobTitleID INTEGER

Procedure Flow

 * 1) Determine what the Weekly Summary Type is based upon the Weekly Summary Type Description passed in by the caller.  If the description can not be found in the table LU_WeeklySummaryType throw an error and abort.
 * 2) Create a temp table from the data passed in from the XML
 * 3) Insert those records from the temp table into the table Sales.dbo.WeeklySummary