Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP AGGREGATE OdchStd
- GO
- DROP ASSEMBLY OdchStd
- GO
- CREATE ASSEMBLY OdchStd
- FROM 'C:\e740\repos\FunAggr2\FunAggr2\bin\Debug\FunAggr2.dll'
- WITH PERMISSION_SET = SAFE;
- GO
- CREATE AGGREGATE OdchStd(@s FLOAT)
- RETURNS FLOAT
- EXTERNAL NAME OdchStd.OdchStd;
- GO
- SELECT Dzialy.Nazwa, stdev(wzrost) AS [stdev], dbo.OdchStd(Wzrost) AS [odch], (stdev(wzrost) - dbo.OdchStd(Wzrost))/stdev(wzrost)
- FROM Dzialy LEFT JOIN osoby ON
- Dzialy.IdDzialu=Osoby.IdDzialu GROUP BY Dzialy.Nazwa
Add Comment
Please, Sign In to add comment