Here is the 'Donations' table with sample data:
Bank_Account | Amount | Reference | Payment_Method | Rate | Date |
B33 | 10 | 12345 | CC | DWM | 21/07/07 |
I need a stored procedure that will check to see if a matching Reference number already exists and if it does to reinsert the Bank_Account, Payment_Method, Refrence and Rate details into the same Donations table. The 'Amount' figure will be passed into it from the application, and I need today's date for the Date column (using GetDate())
All replies appreciated!