USP_GETTASKSTATUS_MEMBERSHIPPROGRAMS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STATUS | tinyint | INOUT | |
| @DESCRIPTION | nvarchar(max) | INOUT | |
| @CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_GETTASKSTATUS_MEMBERSHIPPROGRAMS
(
@STATUS tinyint = null output,
@DESCRIPTION nvarchar(max) = null output,
@CURRENTAPPUSERID uniqueidentifier
)
as begin
exec dbo.USP_DATALIST_MEMBERSHIPPROGRAM @CURRENTAPPUSERID;
set @STATUS = (case when @@ROWCOUNT > 0 then 2 else 0 end);
end