“<i>I can only get column names to return</i>”
This means that there are no records matching your WHERE clause.
Then only query that includes a WHERE clause is this:
<pre>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’ </pre>
And it is not returning any rows.
I would try removing all conditions from this query’s WHERE clause, and start adding them back one at a time, to see which is the one causing the problem.