USP_DATALIST_MICROSITE_PAGES

CREATE procedure dbo.USP_DATALIST_MICROSITE_PAGES(
@SITECONTENTID int = null,
@WITHEXCLUDED bit = 0 
)
as
    set nocount on;

select 
    MICROSITEPAGE.ID,
    SITEPAGESID,    
    TABLECATALOGID,
    OBJECTID,
    PRIMARYCONTENTID,
    EXCLUDED,
    TABLENAME,    
    DESCRIPTION    
from dbo.MICROSITEPAGE
left outer join dbo.TABLECATALOG 
    on MICROSITEPAGE.TABLECATALOGID = TABLECATALOG.ID 
where 
    PRIMARYCONTENTID = ISNULL(@SITECONTENTID, PRIMARYCONTENTID)
    and ((EXCLUDED = 0) or (@WITHEXCLUDED = 1))