fnGetPageLayoutID

     create FUNCTION dbo.fnGetPageLayoutID(
      @PageID int
      )
          RETURNS int AS 
          BEGIN

            declare @TemplatePageId int
            declare @LayoutId int

            select @TemplatePageId = TemplatePageID from SitePages where ID = @PageID

        if (@TemplatePageId > 0)
                select @LayoutId = TemplateID from SitePages where ID = @TemplatePageId
        else
            select @LayoutID = TemplateID from SitePages where ID = @PageID

        return @LayoutId
    END