I need to create a select statement in which one of the columns is a running count starting from a number of my choosing. So like this:
Col1 Col2 Num
Row Row 1
Row Row 2
Row Row 3
Row Row 4
How can I do that without using variables or a loop etc?
Edit: What I mean is something similar to IDENTITY-function without having to use it with INTO.
View Complete Post