SQL Function to get Max, Min values from given collection of values

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

nigel. SSChampion Points: 11636 More actions · Answer 1

An alternative (simply a refactor):

DECLARE @v-2 VARCHAR(1000)

SET @v-2 = '2,22,5,1,88,2000,7897,800'

SELECT CAST( x.query('fn:min(number)') AS varchar),

CAST( x.query('fn:max(number)') AS varchar),

CAST( x.query('fn:count(number)') AS varchar)

FROM

(

SELECT CAST('<number>' + REPLACE(@v,',','</number><number>') + '</number>' AS XML) AS X

) s

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

SSC Guru

Points: 76202

May 17, 2016 at 7:01 am

Thanks for the script.