Replies

Stupid question…. Do you use this as a stored procedure or a local package?

If I would use a cursor, can you give me an example of the code used to declare the cursor? I see the pseudo-code listed above, but I am not certain how to declare the cursor. Would it be something like this:

DECLARE temp_cursor CURSOR
FOR SELECT * FROM temp
OPEN temp_cursor
FETCH NEXT FROM temp_cursor

If this is correct, I am not sure where to go from here. Thanks again

If I would use a cursor, can you give me an example of the code used to declare the cursor? I see the pseudo-code listed above, but I am not certain how to declare the cursor. Would it be something like this:

DECLARE temp_cursor CURSOR
FOR SELECT * FROM temp
OPEN temp_cursor
FETCH NEXT FROM temp_cursor

If this is correct, I am not sure where to go from here. Thanks again

How would you do it if you didnt use a cursor. Through some research, I have learned that a cursor is not the easiest way to go about things. Maybe I am wrong and I do need to use a cursor?

How would you do it if you didnt use a cursor. Through some research, I have learned that a cursor is not the easiest way to go about things. Maybe I am wrong and I do need to use a cursor?

Mark,

I am trying to do it with the DTS. The data in the CSV file with have the Last Name, First Name, Title, Phone Number, Extension, and Address. Each have their own column. The last name and first name need to be used as the primary key. If the name changes, then it will be a new row. However if the title, phone number, extension, or address change, I need to replace the old data with the updated data. I have been trying to do it by inserting the CSV file into a temp table and the searching the data in the temp table to find the new data, but I am not having any luck. Any help is appreciated.

Thanks,
Nick

Mark,

I am trying to do it with the DTS. The data in the CSV file with have the Last Name, First Name, Title, Phone Number, Extension, and Address. Each have their own column. The last name and first name need to be used as the primary key. If the name changes, then it will be a new row. However if the title, phone number, extension, or address change, I need to replace the old data with the updated data. I have been trying to do it by inserting the CSV file into a temp table and the searching the data in the temp table to find the new data, but I am not having any luck. Any help is appreciated.

Thanks,
Nick

I did that and it compiled, but now I get an error on a different form. I have posted the stripped down version.

I did that and it compiled, but now I get an error on a different form. I have posted the stripped down version.

None, If it was an easy fix I was going to do it. The blank menu bar works fine.

Thanks

None, If it was an easy fix I was going to do it. The blank menu bar works fine.

Thanks

thanks HansV, the debug pointed them out
I had a couple syntax errors

thanks HansV, the debug pointed them out
I had a couple syntax errors

thanks

thanks