SQL Server 2005 stdevp function

i unable stdevp function work.  query follows:

select     stdevp(schedule_weight) expr1
from         order_start_steps_weights
where     (schedule_weight_type = 1)

when try execute query (from either bids or ssms) query gets changed to:

select     count_big(schedule_weight) expr1
from         order_start_steps_weights
where     (schedule_weight_type = 1)

i should mention stdev function works fine if substitute stdevp function.

needless say, there big difference between counting population , finding standard deviation of population.

have hit bug?  in advance.

steve wells

 

 

this has been address in http://forums.microsoft.com/msdn/showpost.aspx?postid=268240&siteid=1

cheers,
dan

SQL Server  >  SQL Server Tools