I needed this great script just today. Thanks.

Finding meadian value of field Number in table SampleData

DECLARE@Median FLOAT;

SELECT@Median = ISNULL(AVG([Number]), 1)

FROM(

SELECT[Number],

ROW_NUMBER() OVER ( ORDER BY [Number] ASC ) AS [NumberRank],

(

SELECTCOUNT(*)

FROM[SampleData]

) AS [NumberCount]

...

Just right. Thanks as lot.

Maybe also to add

USE master

GO

first, as your current database might not be in the required compatibility mode 😉

-

Regards

Flemming Hansen

Msg 102, Level 15, State 1, Line 33

Incorrect syntax near 'dec'.:hehe: