-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
SELECT f2,f1 FROM t1
GO

SELECT f2,f1 FROM t1
UNION
SELECT 'Total',SUM(f1) FROM t1
GO
