USP_SIMPLEDATALIST_DESIGNATION_PURPOSE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PURPOSEID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_DESIGNATION_PURPOSE (@PURPOSEID uniqueidentifier = null)
as
begin
select ID as VALUE
,USERID as LABEL
from dbo.DESIGNATION
where SYSTEMGENERATED=0 and (DESIGNATIONLEVEL1ID = @PURPOSEID
or DESIGNATIONLEVEL2ID = @PURPOSEID
or DESIGNATIONLEVEL3ID = @PURPOSEID
or DESIGNATIONLEVEL4ID = @PURPOSEID
or DESIGNATIONLEVEL5ID = @PURPOSEID)
order by USERID;
end