UFN_COMBINATIONAVAILABILITY_SALESMETHODSLIST

This function returns combination availability sales methods as a list given its ID.

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@COMBINATIONAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_COMBINATIONAVAILABILITY_SALESMETHODSLIST
            (
             @COMBINATIONAVAILABILITYID uniqueidentifier
            )
            returns nvarchar(200) AS  

            BEGIN 
             DECLARE @SALESMETHODSLIST nvarchar(100)

             SELECT @SALESMETHODSLIST = COALESCE(@SALESMETHODSLIST + ', ', '') + (SALESMETHODLIST.[TYPE])
             FROM
               ( select SALESMETHOD.[TYPE]
                    from dbo.COMBINATIONAVAILABILITYSALESMETHOD
                        inner join dbo.SALESMETHOD on COMBINATIONAVAILABILITYSALESMETHOD.SALESMETHODID = SALESMETHOD.ID  
                    where COMBINATIONAVAILABILITYID = @COMBINATIONAVAILABILITYID) SALESMETHODLIST

             RETURN @SALESMETHODSLIST
            END