CREATE PROCEDURE rsp_issues_per_week  @ClientID integer
AS
SET NOCOUNT ON

SELECT dbo.Issue.IssueID, dbo.Issue.OpenDate, dbo.Issue.TargetDate, dbo.Issue.ClosedDate,
CASE 
	WHEN ClosedDate IS NOT NULL THEN 'Closed'
	WHEN TargetDate < GetDate() AND ClosedDate IS NULL THEN 'Overdue'
             ELSE 'Open' 
END 
AS Status,
Case WHEN ClosedDate IS NOT NULL Then 1
	Else 0
END 
AS BClosed,
Case WHEN TargetDate < GetDate() AND ClosedDate IS NULL THEN 1
	Else 0
END
AS BOverdue,
CASE WHEN ClosedDate IS NULL And GetDate() < TargetDate THEN 1
	Else 0
END
As BOpen
FROM dbo.Issue INNER JOIN dbo.Client ON dbo.Issue.ClientID = dbo.Client.ClientID
WHERE (dbo.Issue.OpenDate >= GETDATE() - 7)
SET NOCOUNT OFF
GO