Stored Procedure

hi Coders I have a a stored proc which executes fine but doesnt work when called from asp.net page. Scenario is: I need to insert values in the table and get Identity which is fine, but the condition is if a value exist with the same ID I need to delete it and Insert a new record and get the ID, Please look at this and let me know if you have any other option ############################### the sored proc is in attached file ################################ because the stored proc has a parameter symbol the RAC classifies it as an email so I have published it as a text document..please have a look at this url [login to view URL] regards ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform xp, [login to view URL]