USP_SIMPLEDATALIST_SCHEDULEDPROGRAMBYSALESMETHOD
Returns a list of scheduled programs for a given sales method.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESMETHODTYPECODE | tinyint | IN | SALESMETHODTYPECODE |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_SCHEDULEDPROGRAMBYSALESMETHOD
(
@SALESMETHODTYPECODE tinyint
)
as
select
PROGRAM.ID as VALUE,
PROGRAM.NAME as LABEL
from
dbo.PROGRAM
inner join
dbo.PROGRAMSALESMETHOD on PROGRAM.ID = PROGRAMSALESMETHOD.PROGRAMID
inner join
dbo.SALESMETHOD on PROGRAMSALESMETHOD.SALESMETHODID = SALESMETHOD.ID
where
PROGRAM.ISDAILYADMISSION = 0
and SALESMETHOD.TYPECODE = @SALESMETHODTYPECODE
and PROGRAM.ISPREREGISTERED = 0
order by
PROGRAM.NAME;
return 0;