USP_SEARCHLIST_DESIGNATIONLEVELRECIPIENT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MAXROWS | smallint | IN | |
| @USERDEFINEDID | nvarchar(110) | IN |
Definition
Copy
CREATE procedure dbo.USP_SEARCHLIST_DESIGNATIONLEVELRECIPIENT
(
@MAXROWS smallint = 500,
@USERDEFINEDID nvarchar(110) = null
)
as
set nocount on;
select top(@MAXROWS)
DESIGNATIONLEVELRECIPIENT.ID ID
from
dbo.DESIGNATIONLEVELRECIPIENT
where
DESIGNATIONLEVELRECIPIENT.USERDEFINEDID = @USERDEFINEDID;