sql server - SQL STDEV on a calculate column -
so have 2 columns want division on want stdev on resulting column trying following sql doesnt work havent been able figure out how save internal select variable , stdev on var. barking wrong tree? ideas?
select stdev( select convert(decimal(20,5),convert(decimal(20,5),(s.received)) /convert(decimal(20,5),(s.sent)))*100 ddr sometable s s.somethingname = 'thisthingsname' , s.date '2015-04-16%' ) sometable
select stdev( convert(decimal(20,5),convert(decimal(20,5),(s.received)) / convert(decimal(20,5),(s.sent)))*100 ) deviation sometable s s.somethingname = 'thisthingsname' , s.date '2015-04-16%'
please note if version of sql server 2008 or higher, can
and cast(s.date date) = '2015-04-16'
and in sql server 2012 can
and cast(s.date date) = datefromparts(2015,04,16)
rather (non-exact!) string comparison on date field.
Comments
Post a Comment