We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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.
|SQL Server show list of tables from a database with a parameter for the Database name||18||38|
|Changing the Schema for all Tables in a Tables - MS SQL Server 2008 R2.||3||32|
|Estimating my database size||7||13|