USP_BBNC_DESIGNATIONSBYMAPIDS

List of all designation guids with the given map ids.

Parameters

Parameter	Parameter Type	Mode	Description
@MAPIDSLIST	nvarchar(2000)	IN	Designations to include

Definition

Copy



                CREATE PROCEDURE USP_BBNC_DESIGNATIONSBYMAPIDS (@MAPIDSLIST nvarchar(2000) = '')
        AS
        BEGIN
                declare @designationIDsTable table (id int)

                insert into @designationIDsTable
                select id from dbo.fnMakeIDsTableFromString(@MAPIDSLIST, ',')

                select D.ID, map.ID as MapID, D.VANITYNAME
                from
                dbo.BBNCDESIGNATIONIDMAP map
                inner join @designationIDsTable ids on ids.id = map.ID
                inner join  dbo.DESIGNATION D on D.ID = map.DESIGNATIONID 
        END