fnSiteContentIsPublished

CREATE FUNCTION [dbo].[fnSiteContentIsPublished]
    (@ID int, @CurrentDate datetime)
RETURNS bit
AS
BEGIN
    DECLARE @IsTimePublished bit
    DECLARE @PublishDate datetime
    DECLARE @ExpireDate datetime
    DECLARE @Published bit
    SET @Published = 0

    SELECT @IsTimePublished = IsTimePublished, @PublishDate = PublishDate, @ExpireDate = ExpireDate
    FROM SiteContent
    WHERE ID = @ID

    IF @@ROWCOUNT <> 1
        SET @Published = 1
    ELSE IF @IsTimePublished = 0
        SET @Published = 1
    ELSE IF @CurrentDate >= @PublishDate and @ExpireDate >= @CurrentDate
        SET @Published = 1
RETURN @Published
END