>Con il Max che mi dici tu potrei farlo?
Certo:
WITH CTE_Union AS
(
SELECT 100 AS Col1, 0 AS Col2
UNION ALL
SELECT 0, 450
)
SELECT MAX(Col1) AS Col1, MAX(Col2) AS Col2
FROM CTE_Union;
/* Output:
Col1 Col2
----------- -----------
100 450
(1 row(s) affected)
*/
Ciao!
--
Lorenzo Benaglia
Microsoft MVP - SQL Server
http://blogs.dotnethell.it/lorenzo/
http://italy.mvps.org