USP_DATALIST_BATCHREGISTRANTDESIGNATION

Displays the designations for a given batch revenue registrant.

Parameters

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

Definition

Copy



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

    if @MAXROWS is not null
      set rowcount @MAXROWS;

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

    set rowcount 0;