Hi,
I have a requirment where in i need to check if records exists for a perticular id if so delete all and insert new records on that ID. Updating dosent work as the number of records may differ.
I am using two sp to do this one is to delete the existing records and second is to insert new records... but some time i get time out exception.. as you can guess that the sp dont do much work except having single statement to insert or delete. How do i
work around this. Any suggestions pls
Thanks and Regards,
N1ZAM
Go to the complete details ...