Listing 2: SQL Statement That Queries Listing 1's Stored Procedure

CREATE PROCEDURE [GET_BKG_Stock] ( 
@BKGID int 
) 
AS 
SELECT 
     [Stock_Description], 
     [Start_Date], 
     [Duration], 
     [Quantity], 
     [Rate_Quoted] 
FROM 
     [BKG_Stock] 
WHERE 
     [BKG_Stock].[BKG ID] = @BKGID 
ORDER BY 
     [Stock_Description], 
     [Start_Date], 
     [Duration], 
     [Quantity],