UFN_DISCOUNTAVAILABILITY_CONSTITUENCYCODESLIST

This function returns discount availability constituency codes as a list given its ID.

Return

Return Type
nvarchar(2000)

Parameters

Parameter	Parameter Type	Mode	Description
@DISCOUNTAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_DISCOUNTAVAILABILITY_CONSTITUENCYCODESLIST
            (
             @DISCOUNTAVAILABILITYID uniqueidentifier
            )
            returns nvarchar(2000) AS  

            BEGIN 
             DECLARE @CONSTITUENCYCODESLIST nvarchar(2000)

             SELECT @CONSTITUENCYCODESLIST = COALESCE(@CONSTITUENCYCODESLIST + ', ', '') + (CONSTITUENCYCODESLIST.DESCRIPTION)
             FROM
                (select CONSTITUENCYCODE.DESCRIPTION from dbo.DISCOUNTAVAILABILITYCONSTITUENCY
                    inner join dbo.CONSTITUENCYCODE on DISCOUNTAVAILABILITYCONSTITUENCY.CONSTITUENCYCODEID = CONSTITUENCYCODE.ID
                    where DISCOUNTAVAILABILITYID = @DISCOUNTAVAILABILITYID) CONSTITUENCYCODESLIST

             RETURN @CONSTITUENCYCODESLIST
            END