USP_SIMPLEDATALIST_SITEBYCLIENT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLIENTSITE | int | IN | |
| @PAGENAME | nvarchar(510) | IN |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_SITEBYCLIENT
(
@CLIENTSITE integer,
@PAGENAME NVARCHAR(510) = NULL
)
as
select
ID as VALUE,
PageName as LABEL
from dbo.SitePages
WHERE ClientSitesID = @CLIENTSITE
AND PageName = ISNULL( @PAGENAME, PageName )
order by PageName