USP_SITEPAGES_URLSFORSITE

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTSITESID	int	IN

Definition

Copy



create procedure dbo.USP_SITEPAGES_URLSFORSITE(@CLIENTSITESID int)
as
begin
    select ID, URL
    from dbo.[SitePages]
    where 
        IsTemplatePage = 0 and
        ClientSitesID = @CLIENTSITESID and 
        URL is not null
    order by URL;
end