UFN_COMBINATIONAVAILABILITY_CONSTITUENCYCODESLIST

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

Return

Return Type
nvarchar(2000)

Parameters

Parameter	Parameter Type	Mode	Description
@COMBINATIONAVAILABILITYID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_COMBINATIONAVAILABILITY_CONSTITUENCYCODESLIST
            (
             @COMBINATIONAVAILABILITYID uniqueidentifier
            )
            returns nvarchar(2000) AS  

            BEGIN 
             DECLARE @CONSTITUENCYCODESLIST nvarchar(2000)

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

             RETURN @CONSTITUENCYCODESLIST
            END