|
Vivaldi
Constraint Violating Yak Guru
USA
298 Posts |
 Posted - 07/12/2001 : 09:24:01
|
Hey all,
Basic question,
I have a table structure as so.
Title
id | title
Component
ID | code | titleid
County
id | countyname
countybudget
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?
Thanks much
Software Composer |
|
copying elements more efficiently
