I'm getting a domain error when using the STDEV function.
Seems to be keyed to specific numbers.
Here is an example of the data being used:
Create Table Test(
Code varchar(10),
Amt money )
go
set nocount on
declare @x int
set @x = 1
while @x < 10
begin
Insert into Test values ('abcd',15.46)
set @x = @x + 1
end
go
SELECT Code,
stdev(Amt) as Deviation
FROM Test
group by Code
Seems to be keyed to specific numbers.
Here is an example of the data being used:
Create Table Test(
Code varchar(10),
Amt money )
go
set nocount on
declare @x int
set @x = 1
while @x < 10
begin
Insert into Test values ('abcd',15.46)
set @x = @x + 1
end
go
SELECT Code,
stdev(Amt) as Deviation
FROM Test
group by Code