DBA12345 (4/17/2013)
Hi Thanks for your reply...I am not getting the result with your query. I have written like below.for the belwo proc few folks in this same forum suggesting me to write using merge statement. but I am not getting from any of them. Please check it once and let me know if you need additional info.
...
And in that thread (which by the way I just checked and there is nothing more there for us to work with) we asked you for the same things we are asking for here.
If you want help you have to help us. We need the DDL (CREATE TABLE statement) for the table(s) involved, sample data (as a series of INSERT INTO statements) for the table(s) involved and in this case would also require sample data for the update/insert process, expected results based on the sample data.
Without this all you are going to get is guess work. Eventually we may actually hit what you need, but if you help us help you, you will get better answers faster and tested code in return.