Constraint Violating Yak Guru
Posted - 07/12/2001 : 09:24:01
| Hey all,
I have a table structure as so.
id | title
ID | code | titleid
id | countyname
id | countyid | componentid | money
the asp page passes
1 - N county ids and a title id
I want to copy all componentids for a given titleid into the CountyBudget Table for each county.
However, I only want to insert if the record does not exist.
This is quite simple in ASP, create an array of the components and run some code within a Loop, but this is very INefficient and I am trying to improve my use of stored procs.
Is there a way that is better than simply using a cursor and doing the logic?