USP_DATALIST_PROMOTIONALCODE
Displays a list of promotion codes.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DISCOUNTID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
create procedure dbo.USP_DATALIST_PROMOTIONALCODE
(
@DISCOUNTID uniqueidentifier
)
as
set nocount on;
select ID,
PROMOTIONALCODE,
VALIDFROM,
VALIDTO
from dbo.PROMOTIONALCODE
where DISCOUNTID = @DISCOUNTID
order by SEQUENCE;
return 0;