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!
sqlstring1 = "select observation_date, station_id, min(TempF),max(TempF),avg(TempF)from (select dateadd(d, datediff(d, 0, convert(datetime, observation_date, 101)),0) as observation_date, station_id, cast(TempF as numeric(6,2)) as TempF from weather where (station_id = '" & querywthr1 & "') and convert(datetime, observation_date, 101) >= '" & date_range_start & "' and convert(datetime, observation_date, 101) < '" & date_range_end + 1 & "' )a group by observation_date,station_id order by observation_date"
Join the community of 500,000 technology professionals and ask your questions.