USP_DATALIST_DESIGNATIONALTLOOKUPIDS

Returns a list of alternate lookup IDs for a designation.

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DESIGNATIONALTLOOKUPIDS
                (
                    @DESIGNATIONID uniqueidentifier
                )
                as
                set nocount on;

                select
                    DESIGNATIONALTLOOKUPID.ID,
                    DESIGNATIONALTLOOKUPIDTYPECODE.DESCRIPTION as [TYPE],
                    DESIGNATIONALTLOOKUPID.ALTLOOKUPID
                from dbo.DESIGNATIONALTLOOKUPID
                inner join dbo.DESIGNATIONALTLOOKUPIDTYPECODE on DESIGNATIONALTLOOKUPIDTYPECODE.ID = DESIGNATIONALTLOOKUPID.ALTLOOKUPIDTYPECODEID
                where DESIGNATIONALTLOOKUPID.DESIGNATIONID = @DESIGNATIONID
                order by DESIGNATIONALTLOOKUPIDTYPECODE.DESCRIPTION