Recent content by hlbyrdman

Thank you, It turns out I had a combination of errors. In an earlier version I was trying to do this without a curser, and neglected to remove the select statement when I shifted gears. It didn't make it fail but it was VERY slow. I had to rewrite the select statement. To only pick up the task...

I have posted this before and recieved no help. I here rephrase the question and pared down the code. Hopefully I will get it right and someone will be able to help. my task is to move data from MS Access into SQL. I created a DTS package which creates a new table in SQL filled with the Access...

Sorry to post this again but I really am lost with it and do need help. I have data in a MDB table I need to use to update a SQL table. I have imported it into SQL with A DTS package. So far all is good. I then need to update another SQL table and continue the row_id's that are already in the...

By inherited I am explaining that the database is what it is with 200,000 records already there so changing the way it relates data is not an option.

First I inherited this data base, Job_charges includes row_id the new data is coming in from several other sources, so I need a way to generate new row_id's that are contiguose with the existing row_id's. I am not married to the cursor as a method for inserting data, if anyone has other...

I was hoping someone would say that.. CREATE PROCEDURE [update_JM_Updatetbl] ( @charge_date_1 [datetime], @charge_time_2 [datetime], @job_number_3 [int], @job_name_4 [nvarchar](40), @charge_date_5 [datetime], @charge_time_6 [datetime], @start_time_7 [datetime], @end_time_8...

I have created a stored procedure that picks data from one table and appends it to another. I used a curser so it would step through the table a row at a time. My problem is it sometimes duplicates a row or two and creates multiple copies of the same record. The procedure always returns the...