Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.
DECLARE @StartDate AS DATETIME,@EndDate AS DATETIME SET @StartDate = '12/01/2013' SET @EndDate = '12/31/2013' SELECT DATEDIFF(mi,EI.DateOfCall,CA.DateOfAssessment) AS 'ResponseTime', CA.AssessmentLocation FROM EncounterInformation AS EI LEFT JOIN CrisisAssessment AS CA ON EI.CrisisAssessmentID = CA.CrisisAssessmentID LEFT JOIN EncounterDispositionMapping AS EDM ON EI.EncounterInformationID = EDM.EncounterInformationID LEFT JOIN DispositionInformation AS DI ON EDM.DispositionInformationID = DI.DispositionInformationID WHERE DateOfCall BETWEEN @StartDate AND DATEADD(hh,24,@EndDate) AND (CA.AssessmentLocation LIKE 'Methodist%') GROUP BY CA.AssessmentLocation
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.