Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
SELECT b.BPID, a.EntityShortName, b.DateEntered, DateDiff(day,b.DateEntered,GetDate()) DaysSinceLastBP FROM BP AS b INNER JOIN RiskMgmtAssignments AS a ON b.EntityID = a.EntityID INNER JOIN RMCs AS rm ON a.RMCID = rm.ID WHERE (b.IsComplete = 1) AND (rm.Name = @username) ORDER BY DateDiff(day,b.DateEntered,GetDate()) DESC
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.