Hi guys,
I need to return a dataset to a vb.net program with weekly averages.
So far I have:
I was hoping somebody could shed some light on why this doesn't work?
I need to return a dataset to a vb.net program with weekly averages.
So far I have:
Code:
SELECT AVG(a) as A, AVG(b) as B FROM results WHERE fk=0 GROUP BY DATEPART(ww,myDateTime)
I was hoping somebody could shed some light on why this doesn't work?