Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
SELECT Member.MemberID, '01/01/1900' as servicedate , 'HRA-Triglyceride' as loincCode,null as cpt_Code , a.hramadAnswer as llc_Value FROM HRAMemAnswerData a WITH(NOLOCK), PopulationTask t, HRAGroupQuestions gq, HRAQuestion q INNER JOIN Member ON Member.MemberGUID=t.MemberGUID where a.PopulationTaskID = t.PopulationTaskID And a.HragqID = gq.HragqID And gq.HragqChildqID = q.HraqID and hraqid = 19 and Member.MemberID = @MemberID AND T.Active = 0 AND LEFT(a.hramadAnswer, 3) = 'Yes' AND LTRIM(RTRIM(SUBSTRING(a.hramadAnswer, 5, LEN(a.hramadAnswer)))) != '' and Member.ClientID = @ClientID and Member.MemberID = @MemberID ORDER BY ServiceDate DESC
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!