USP_DATALIST_PROGRAMSALESMETHOD

Lists all Sales Methods for a Program

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_PROGRAMSALESMETHOD(@CONTEXTID uniqueidentifier)
      as
          set nocount on;

          select 
              PROGRAMSALESMETHOD.ID,
              PROGRAMSALESMETHOD.SALESMETHODID,
              SALESMETHOD.TYPE,
              dbo.UFN_PROGRAMSALESMETHOD_ONSALEINFORMATION(PROGRAMSALESMETHOD.ID) as ONSALE,
              case PROGRAMSALESMETHOD.ONSALEENDTYPECODE
                when 0 then
                    PROGRAMSALESMETHOD.ONSALEENDTYPE
                else
                    cast(PROGRAMSALESMETHOD.ONSALEENDINTERVAL as nvarchar(12)) + ' ' + PROGRAMSALESMETHOD.ONSALEENDTYPE
                end as OFFSALE
          from dbo.PROGRAMSALESMETHOD
              inner join dbo.SALESMETHOD on PROGRAMSALESMETHOD.SALESMETHODID = SALESMETHOD.ID
          where PROGRAMID = @CONTEXTID