DECLARE @SQL NVARCHAR(MAX) DECLARE @SumValue INT SET @SQL = N'SELECT @SumValue = Sum(Money) FROM CONTRACT' execute sp_executesql @SQL,N'@SumValue INT OUTPUT',@SumValue OUTPUT print @v_SumValue