Listing 1: Stored Procedure That Creates a List of Cost Elements

CREATE TABLE [BKG_Stock] ( 
     [ID] [int] IDENTITY (1, 1) NOT NULL , 
     [BKG_ID] [int] NOT NULL , 
     [Quantity] [int] NOT NULL , 
     [Duration] [int] NOT NULL , 
     [Start_Date] [smalldatetime] NOT NULL , 
     [Rate_Quoted] [money] NOT NULL , 
     [Stock_Description] [varchar] (70) 
) ON [PRIMARY]