UFN_CLIENTSITE_ISPUBLISHED

create function dbo.UFN_CLIENTSITE_ISPUBLISHED(@CLIENTSITESID int)
returns bit
with execute as caller
as begin
    -- do work here and return a value


    declare @PUBLISHEDDATE datetime
set @PUBLISHEDDATE = (select top 1 a.AuditDate
                        from dbo.Audits a
                        inner join dbo.ClientSites CS on CS.Guid = a.ObjectGuid
                        where CS.ID = @CLIENTSITESID and a.AuditCodesID = 7
                        order by a.AuditDate desc)    

declare @UNPUBLISHEDDATE datetime
set @UNPUBLISHEDDATE = (select top 1 a.AuditDate
                        from dbo.Audits a
                        inner join dbo.ClientSites CS on CS.Guid = a.ObjectGuid
                        where CS.ID = @CLIENTSITESID and a.AuditCodesID = 8
                        order by a.AuditDate desc)    
declare @PUBLISHED Bit
if @PUBLISHEDDATE IS NOT NULL AND (@UNPUBLISHEDDATE Is Null OR @PUBLISHEDDATE > @UNPUBLISHEDDATE)
    set @PUBLISHED = 1
else
    set @PUBLISHED = 0

    return @PUBLISHED
end