How to auto-increment into other columns

Question

my question is

how to sum and auto-increment into other column when we insert into column 1

id	Column1(Inserted)	column2(Auto-increment column)
1	10	10
2	10	20
3	20	40
4	30	70

how to perform this and what is the query for this kind of result

Midhun Tp · Answer

Hi, Please try below query - DECLARE @val FLOAT; SET @val=10 INSERT INTO tablename (col1, col2) SELECT @val,isnull(sum(col1),0)+@val FROM tablename

Nitin Sontakke · Answer

I would strongly discourage you from doing anything like this. What is the purpose? What is the exact reason for doing this? Such data can always be built with a simple select statement. So please share the rationale behind this. Technically, we can do anything, but there is always a best way to achieve the end result.

Manish Kumar · Answer

declare @t table (id int) insert into @t select 10 union all select 20 union all select 30 union all select 40 select id ,sum(id) over (order by id ) from @t

Jitendra Shekhawat · Answer

http://stackoverflow.com/questions/5669198/how-do-i-auto-increment-a-column-in-my-table http://stackoverflow.com/questions/5931472/insert-auto-incremented-value-into-another-tables-column http://stackoverflow.com/questions/15823814/multiple-identity-columns-or-a-way-to-auto-increment

Ramesh Palanivel · Answer

Hi Riya, Create a stored procedure and perform a calculation and store the result in table while inserting the record. It will help you!.. Note( If the calculation has dynamic calculations)