UFN_DISCOUNTAVAILABILITY_SALESMETHODSLIST

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

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_DISCOUNTAVAILABILITY_SALESMETHODSLIST
            (
             @DISCOUNTAVAILABILITYID uniqueidentifier
            )
            returns nvarchar(200) AS  

            BEGIN 
             DECLARE @SALESMETHODSLIST nvarchar(100)

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

             RETURN @SALESMETHODSLIST
            END