Show Bid Request Simple SQL Stored Procedure Bid Request Id: 44666 Bookmark in my 'To Do' list Posted by: Mikeeee (7 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 20.00% Buyer Security Verifications: Good Approved on: Jan 21, 2003 1:11:30 PM EDT Bidding Closes: Jan 24, 2003 1:17:45 PM EDT Viewed (by coders): 84 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Question or Beginner / Newbie Assistance Bidding Type: Open Auction Categories: Database, SQL Server Enter chat room for this bid request (0 active users at Sep 30, 2003 7:12:35 AM EDT) Description: just require what I think should be a simple SQL storred procedure! to move a record from one table to a second table and delete it from the source table. I have it working as three stored procedures one to return the record set, one to save new data in table and the third to delete the source record. I have looked arround and cant find an example procdeure that does this in one. Is this possiable? I pass down the Unique record ID and the destination table name. The field entries are the same for all source and return tables. Wish to return a succes or failed flag. Anybody help with a quick demo that I can modify for my app? 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: 2000 Avanced server, SQL 2000 latest sp Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! IanPayne (9 ratings) in Bearpark, Durham United Kingdom Bid id: 482,425   $8 (USD) Jan 21, 2003 1:32:01 PM EDT  10 (Excellent)     Mike, No problem (so long as you know in advance what the table structures are!) Ian           There are 1 private replies to/from IanPayne. Click here to view them.