Here is my dilemma:

I'm working on a project where I need to import data from Excel into SQL Server for storage. The way I have it working is DTS pulls the information into temp tables so I can scrub the data (remove null rows, etc). Then a stored procedure pulls the data from the temp table into a supertype table where primary keys are assigned in an IDENTITY column. The primary keys are then pulled into separate subtype tables. I'm using a cursor when I pull the data from the temp table into the supertype table so I can assign the lookup table foreign keys that describe each primary, and then do the same when I move the primary keys to the subtype tables. Unfortunately because of the way SQL Server sorts numbers, my primary keys are not in the order I require. Is there a way around this? If I can provide more clarity to my process here let me know and I'll see what I can do. Thanks in advance

********************
Tim Conlan
DBA Intern
LendingTree, LLC

please post some of your data and the desired result.

I decided to go a different route with this, instead of calling a cursor with the last record, I use the MAX() function which returns my largest value and assign it to a variable. Then I just decrease the value of the variable as I move through the data. Probably not the most efficient or glamorous method, but I'm getting what I want out of it.

Tim
Intern

********************
Tim Conlan
DBA Intern
LendingTree, LLC

Acually, that is the correct way t do it. Using a loop is better than a Cursor... Cursors are pretty much a no-no in SQL.