CREATE TABLE #t (Valores MONEY);

GO

INSERT INTO #t SELECT 1.1;

GO 6

SELECT

SUM(ROUND(Valores, 0)) AS SumRound,

ROUND(SUM(Valores), 0) AS RoundSum

FROM

#t;

DROP TABLE #t;

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]