/****** Object:  StoredProcedure [dbo].[spKartrisBasketValues_GetItems]    Script Date: 07/26/2010 14:17:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[spKartrisBasketValues_GetItems]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
-- =============================================
-- Author:        Joseph
-- Create date: 8/Apr/08
-- Description:    
-- Remarks:    Optimization Medz - 26/07/2010
-- =============================================
CREATE PROCEDURE [spKartrisBasketValues_GetItems] (
    @intLanguageID int,
    @intSessionID int
)
AS
BEGIN

SET NOCOUNT ON;


WITH tblBasketValues as
    (SELECT BV_ID,BV_VersionID,BV_Quantity,BV_CustomText FROM tblKartrisBasketValues WHERE BV_ParentType=''b'' and BV_ParentID=@intSessionID)
    SELECT DISTINCT P_ID''ProductID'',P_Type''ProductType'',T_TaxRate''TaxRate'',V_Weight''Weight'',V_RRP''RRP'',P_Name''ProductName'',V_ID,tblBasketValues.BV_ID
    ,V_Name''VersionName'',V_CodeNumber''CodeNumber'',V_Price''Price'', tblBasketValues.BV_Quantity''Quantity'',V_QuantityWarnLevel''QtyWarnLevel'',V_Quantity,
V_DownloadType,isnull(BV_CustomText,'''')''CustomText'',dbo.fnKartrisBasketOptionValues_GetTotalPriceByParentAndBasketValue(@intSessionID,tblBasketValues.BV_ID) AS OptionsPrice,
V_CustomizationType,V_CustomizationDesc,V_CustomizationCost,tblBasketValues.BV_VersionID FROM tblBasketValues INNER JOIN vKartrisProductsVersions 
ON dbo.fnKartris_GetBaseVersionID(BV_VersionID) = V_ID
 WHERE LANG_ID = @intLanguageID
ORDER BY BV_ID

END
' 
END
GO