USP_DATALIST_EVENTDESIGNATIONS

Displays the designations for this event.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EVENTDESIGNATIONS
                (
                    @EVENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select EVENTDESIGNATION.ID,
                           DESIGNATION.NAME,
                           EVENTDESIGNATION.[DEFAULT]
                    from 
                        dbo.EVENTDESIGNATION
                    inner join DBO.DESIGNATION on EVENTDESIGNATION.DESIGNATIONID=DESIGNATION.ID
                    where 
                        EVENTDESIGNATION.EVENTID = @EVENTID;