Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2001-07-12 : 09:24:01
|
| Hey all,Basic question, I have a table structure as so.Titleid | titleComponentID | code | titleidCountyid | countynamecountybudgetid | countyid | componentid | moneythe asp page passes1 - N county ids and a title idI 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 muchSoftware Composer |
|
|
|
|
|
copying elements more efficiently