Variable in select statement in sql server with increment

Question

I am trying to execute a series of selects in a statement in sql server with a union between them. Now I want in a select statement to include a variable from the t-sql code and increment it with each new entry. How can I do this?

Madhivanan · Accepted Answer · 2014-03-27 08:05:05Z

1

You can use ROW_NUMBER() function instead of a variable

select row_number() over (order by keycol) as row_num, * from
(
Your UNION queries here
) as t

answered Mar 27, 2014 at 8:05

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Variable in select statement in sql server with increment

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related