spLoadRecord_SiteLayouts

CREATE    PROCEDURE [dbo].[spLoadRecord_SiteLayouts]
    (
        @PKID int
    )
AS
    declare @default bit
    set @default = 0

    -- Check ESiteSetting.DefaultTemplateID
    if exists (select 1 from CMSSITESETTING where ENUMID=1 AND CAST(VALUE as int) = @PKID)
        set @default = 1

    select 
        ClientSitesID, 
        Name, 
        Description, 
        ID, 
        Content, 
        Guid, 
        OwnerID, 
        Deleted, 
        Stylesheet, 
        StyleSheetID, 
        DocType,
        @default as 'Default', 
        dbo.fnLastModifiedDate(Guid) LastModifiedDate
    from SiteLayouts
    where ID = @PKID and Deleted = 0