create table numb_tab(col_1 int, col_2 int,col_3 int)
SELECT MIN(col) AS Min, MAX(col) AS Max FROM ( SELECT col_1 AS col FROM numb_tab UNION SELECT col_2 FROM numb_tab UNION SELECT col_3 FROM numb_tab) t
;WITH MinMaxVal AS ( SELECT col_1 As MyVal FROM @numb_tab UNION ALL SELECT col_2 As MyVal FROM @numb_tab UNION ALL SELECT col_3 As MyVal FROM @numb_tab ) SELECT MIN(MyVal) AS MinVal, MAX(MyVal) AS MaxVal FROM MinMaxVal --uncomment below line if execution failed ;) --OPTION (MAXRECURSION 0)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)