Hi, I'm new to this place (and to sql server), I'm having trouble and a friend reccomended I ask here... hope someone can help?
I have an insert statement that is trawling through thousands of records from the source table.
When the cursor finds a bad record from the source(e.g. a null foreign key id) it terminates and then moves on to the next record.
Is there a way I can get the pid recorded in a table?
I have an insert statement that is trawling through thousands of records from the source table.
When the cursor finds a bad record from the source(e.g. a null foreign key id) it terminates and then moves on to the next record.
Is there a way I can get the pid recorded in a table?
