Cursors

I am trying to pull the data via fetching rows into a variable.





Begin


Fetch Next Into @temp...


Select @MainVariable = @MainVariable + @temp < @temp doesn't refresh with next fetch)





Print @temp < this works fine and returns the value for each fetch





End








I can print @temp and the data returns fine, but when I try to cancantenate with the above select, it doesn't refresh @temp wit the column in the table.





Any ideas?





DotNetNow