UFN_SALESORDER_PATRONHASUPGRADE
Returns 1 if the given sales order has a patron that has a mid-term upgrade available
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESORDERID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_SALESORDER_PATRONHASUPGRADE
(
@SALESORDERID uniqueidentifier
)
returns bit
with execute as caller
as begin
declare @CONSTITUENTID uniqueidentifier = (select CONSTITUENTID from dbo.SALESORDER where ID = @SALESORDERID);
if exists (
select MEMBERSHIPID
from dbo.UFN_SALESORDER_GETPATRONUPGRADELEVELS(@CONSTITUENTID)
)
return 1;
return 0;
end