USP_DATALIST_REGISTRANTDESIGNATION

Displays the designations for a given registrant.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_REGISTRANTDESIGNATION
(
    @REGISTRANTID uniqueidentifier,
    @MAXROWS int = null
)
as
    set nocount on;

    if @MAXROWS is not null
      set rowcount @MAXROWS;

    select REGISTRANTDESIGNATION.ID,
           DESIGNATION.NAME,
           REGISTRANTDESIGNATION.AMOUNT,
           EVENT.BASECURRENCYID
    from dbo.REGISTRANTDESIGNATION
        join dbo.DESIGNATION on DESIGNATION.ID = REGISTRANTDESIGNATION.DESIGNATIONID
        join dbo.REGISTRANT on REGISTRANT.ID = REGISTRANTDESIGNATION.REGISTRANTID
        join dbo.EVENT on EVENT.ID = REGISTRANT.EVENTID
    where 
        REGISTRANTID = @REGISTRANTID;

    set rowcount 0;