I have the query below, but when I run it, I can only get column names to return. Can someone please help me??? For each subject there are multiple values at each marker. I want an average, by date, for each subject at each marker. I have spent literally hours on this... Thanks in advance for any help!!!! Lori
select SubjectID ,clinicdate ,avg(JR_RBHo) AVGJR_RBHo ,avg(LL_JRo) AVGLL_JRo ,avg(LL_RBHo) AVGLL_RBHo ,avg(RC_LCo) AVGRC_LCo ,avg(UL_RBHo) AVGUL_RBHo ,avg(UL_LLo) AVGUL_LLo ,avg(UL_RC_LL_LCo) AVGUL_RC_LL_LCo
from ( select SubjectID ,clinicdate ,case Marker when 'JR_RBHo' then MaxSpd else NULL end JR_RBHo ,case Marker when 'LL_JRo' then MaxSpd else NULL end LL_JRo ,case Marker when 'LL_RBHo' then MaxSpd else NULL end LL_RBHo ,case Marker when 'RC_LCo' then MaxSpd else NULL end RC_LCo ,case Marker when 'UL_RBHo' then MaxSpd else NULL end UL_RBHo ,case Marker when 'UL_LLo' then MaxSpd else NULL end UL_LLo ,case Marker when 'UL_RC_LL_LCo' then MaxSpd else NULL end UL_RC_LL_LCo
from ( select distinct SubjectID, clinicdate, Marker, MaxSpd from dbo.BBP_JerkCost_STATS051810
where Marker IN ('JR_RBHo','LL_JRo','LL_RBHo','RC_LCo','UL_RBHo','UL_LLo','UL_RC_LL_LCo') and MaxSpd is not NULL AND SubjectID = '0069' ) x ) xx
group by SubjectID, clinicdate
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!