USP_DATALIST_EVENTSALESMETHOD

Lists all sales types for an Event

Parameters

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

Definition

Copy



      CREATE procedure dbo.USP_DATALIST_EVENTSALESMETHOD(@CONTEXTID uniqueidentifier)
      as
          set nocount on;

          select 
          SALESMETHOD.ID,
          EVENTID,
          TYPE
          from dbo.EVENTSALESMETHOD
        left join SALESMETHOD on
        EVENTSALESMETHOD.SALESMETHODID = SALESMETHOD.ID
          where EVENTID = @CONTEXTID