USP_BBNC_DESIGNATIONSBYGUIDS

List of all designation guids, map ids and vanity name with the given guids.

Parameters

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

Definition

Copy



                CREATE procedure USP_BBNC_DESIGNATIONSBYGUIDS (@GUIDSLIST nvarchar(2000) = '')
                as
                    begin
                        declare @designationIDsTable table (id uniqueidentifier)

                        insert into @designationIDsTable
                            select g from dbo.fnMakeGuidsTableFromString(@GUIDSLIST, ',')

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