DECLARE @a INT, @b INT, @c INT
SET @a = 10
SET @b = 7
SET @c = 12
--sql server 2008 and above
SELECT MAX(v) AS MaxVal
FROM ( VALUES (@a),
(@b),
(@c) ) AS value(v)
--sql server 2005
SELECT MAX(v) AS MaxVal
FROM (SELECT @a UNION
SELECT @b UNION
SELECT @c) AS value(v)
1 comment:
Nice Post 12 Minute Affiliate System
Post a Comment