spGetPageContentListing

create procedure [dbo].[spGetPageContentListing](
    @PKID int
    )
as

        declare @TemplatePageId int
        select @TemplatePageId = TemplatePageID from SitePages where ID = @PKID

    if (@TemplatePageId > 0) begin
        -- Page
        select * from dbo.fnPagePartsList(@TemplatePageId) 
        union
        select * from dbo.fnPagePartsList(@PKID) 
        order by PaneName, TemplateID desc
    end
    else begin
        -- Template
        select * from dbo.fnPagePartsList(@PKID) 
        order by PaneName
    end