Simple is : select 1+2+3+4+5+6+7+8+9+10 OR create table #temp(data int) declare @i int = 1; declare @temp int = 0 ; declare @total int; while (@i <= 10) begin insert into #temp values (@i) set @i = @i+1 end select sum(data) from #temp