-- In SQL70
Declare @myResult As float, @Command As nVarchar(500)
Set @Command = 'Select @outVal = ' + 'ROUND(9.54*(1+0.22)*(1+0)*(1-0)+0.5,0)'
Exec sp_ExecuteSql @Command, N'@outVal float Out', @myResult Out
SELECT @myResult
go
-- In SQL60/65/70
Declare @myResult As float
exec('Declare evalcur Cursor FOR SELECT ' + 'ROUND(9.54*(1+0.22)*(1+0)*(1-0)+0.5,0)')
open evalcur
fetch evalcur into @myResult
deallocate evalcur
select @myResult