USP_DATALIST_COMBINATIONAVAILABILITY

Displays a list of combination availability records.
Parameters

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

Copy


            create procedure dbo.USP_DATALIST_COMBINATIONAVAILABILITY
            (
                @COMBINATIONID uniqueidentifier
            )
            as
                set nocount on;

                declare @COMBINATIONAVAILABILITYCOUNT integer;

                select 
                    @COMBINATIONAVAILABILITYCOUNT = count(*) 
                from
                    dbo.COMBINATIONAVAILABILITY
                where
                    COMBINATIONID = @COMBINATIONID;


                select 
                    ID,
                    dbo.UFN_COMBINATIONAVAILABILITY_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.COMBINATIONAVAILABILITY DA1 where DA1.ID = COMBINATIONAVAILABILITY.ID
                    and (ALLOWSUNDAY = 1 or ALLOWMONDAY = 1 or ALLOWTUESDAY = 1 or ALLOWWEDNESDAY = 1 or 
                    ALLOWTHURSDAY = 1 or ALLOWFRIDAY = 1 or ALLOWSATURDAY = 1)) DA) SELECTEDDAYS,                    
                    ALLOWCOMBINATIONDATEFROM,
                    ALLOWCOMBINATIONDATETO,
                    ALLOWCOMBINATIONTIMEFROM,
                    ALLOWCOMBINATIONTIMETO,
                    @COMBINATIONAVAILABILITYCOUNT COMBINATIONAVAILABILITYCOUNT,
                    SEQUENCE
                from
                    dbo.COMBINATIONAVAILABILITY
                where
                    COMBINATIONID = @COMBINATIONID



                order by SEQUENCE

                return 0;