Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!
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
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.