RE: sequencial insert – SQLServerCentral

SSC Guru

Points: 1003851

March 10, 2013 at 9:57 am

Rauf Miah (3/10/2013)
I like to insert SIRCODE in Sequence like x= x+1000
Then it look like
Comcod Sircode Sirdesc
3306 100001000 A
3306 100002000 B
3306 100003000 C

Yes. We know that. Please see my previous post. We need to know where the "List of Heads" of A, B, C, D "lives" and what format it is in.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)