USP_DATALIST_DISCOUNTAVAILABILITY

Displays a list of discount availability records.
Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


            create procedure dbo.USP_DATALIST_DISCOUNTAVAILABILITY
            (
                @DISCOUNTID uniqueidentifier
            )
            as
                set nocount on;

                declare @DISCOUNTAVAILABILITYCOUNT integer;

                select 
                    @DISCOUNTAVAILABILITYCOUNT = count(*) 
                from
                    dbo.DISCOUNTAVAILABILITY
                where
                    DISCOUNTID = @DISCOUNTID;


                select 
                    ID,
                    dbo.UFN_DISCOUNTAVAILABILITY_SALESMETHODSLIST(ID),
                    (select left(SELECTEDDAYS, len(SELECTEDDAYS) - 1) SELECTEDDAYS from
                    (select case ALLOWSUNDAY when 1 then datename(weekday, '2009-03-08') + ', ' else '' end +
                    case ALLOWMONDAY when 1 then datename(weekday, '2009-03-09')  + ', ' else '' end +
                    case ALLOWTUESDAY when 1 then datename(weekday, '2009-03-10')  + ', ' else '' end +
                    case ALLOWWEDNESDAY when 1 then datename(weekday, '2009-03-11')  + ', ' else '' end +
                    case ALLOWTHURSDAY when 1 then datename(weekday, '2009-03-12')  + ', ' else '' end +
                    case ALLOWFRIDAY when 1 then datename(weekday, '2009-03-13')  + ', ' else '' end +
                    case ALLOWSATURDAY when 1 then datename(weekday, '2009-03-14')  + ', ' else '' end SELECTEDDAYS
                    from dbo.DISCOUNTAVAILABILITY DA1 where DA1.ID = DISCOUNTAVAILABILITY.ID
                    and (ALLOWSUNDAY = 1 or ALLOWMONDAY = 1 or ALLOWTUESDAY = 1 or ALLOWWEDNESDAY = 1 or 
                    ALLOWTHURSDAY = 1 or ALLOWFRIDAY = 1 or ALLOWSATURDAY = 1)) DA) SELECTEDDAYS,                    
                    ALLOWDISCOUNTDATEFROM,
                    ALLOWDISCOUNTDATETO,
                    ALLOWDISCOUNTTIMEFROM,
                    ALLOWDISCOUNTTIMETO,
                    @DISCOUNTAVAILABILITYCOUNT DISCOUNTAVAILABILITYCOUNT,
                    SEQUENCE
                from
                    dbo.DISCOUNTAVAILABILITY
                where
                    DISCOUNTID = @DISCOUNTID



                order by SEQUENCE

                return 0;