Declare @LoggedUserID int =4 SELECT m.*, d.DivisionName, l.Name LocationName, l.Code LocationCode, CASE WHEN mr.MarketingUpdateUnReadID IS NULL THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END IsRead FROM MarketingUpdate m INNER JOIN F_UserDivisions(@LoggedUserID) d on m.DivisionID = d.DivisionID INNER JOIN F_UserLocationHierarchy(@LoggedUserID) l on m.LocationID = l.LocationID LEFT JOIN MarketingUpdateUnRead mr on m.MarketingUpdateID = mr.MarketingUpdateID AND mr.UserID = @LoggedUserID WHERE cast(m.StartDate as date) >= cast(GETDATE() as date) AND (m.EndDate IS NULL OR cast(m.EndDate as date) <= cast(GETDATE() as date)) AND m.IsInActive = 0
WHERE DateDiff(d,@FromDate,GetDate()) >= 0 AND DateDiff(d,@ToDate,GetDate())<= 0
... WHERE m.IsInActive AND (m.EndDate IS NULL OR CAST(GETDATE() AS DATE) BETWEEN m.StartDate AND m.EndDate)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)