UFN_DISCOUNT_GETGROUPSIZES
This function returns a discount's group size data given its ID.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DISCOUNTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_DISCOUNT_GETGROUPSIZES
(
@DISCOUNTID uniqueidentifier
)
returns table
as return
select
[ID],
[GROUPSIZE],
[AMOUNT],
[PERCENT]
from
dbo.[GROUPSIZEDISCOUNT]
where
[DISCOUNTID] = @DISCOUNTID;