How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
(See all)
Chatroom Needed Immediately
By blaster998 on Sep 30
Max Bid: $500


Fix link tracking program
By blaster998 on Sep 30
Max Bid: $75


Install TOMCAT on FreeBSD(repost)
By Kevbob on Sep 30
Max Bid: $100


Stormpay IPN Urgent Help Needed
By rohit123 on Sep 29
Max Bid: Open to fair suggestions


Spyware Application/ Spyware Scanner
By GuyB on Sep 29
Max Bid: $500


Web module in PHP/MySQL
By RXL on Sep 29
Max Bid: Open to fair suggestions


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(175 open)
   Access 
(53 open)
   MySQL 
(113 open)
   Oracle 
(11 open)
   SQL Server 
(72 open)
   Other DB 
(28 open)
Documentation / Tech Writing 
(26 open)
   Language (Human) Translations 
(10 open)
Data Entry 
(37 open)
Game Development 
(26 open)
Graphics / Art / Music 
(60 open)
   Graphics 
(64 open)
     Adobe AfterEffects 
(7 open)
     Adobe Photoshop 
(32 open)
     Adobe Premiere 
(6 open)
     3d Animation 
(21 open)
   Art (Misc.) 
(13 open)
   Music 
(7 open)
   Photography 
(5 open)
   3d Modeling 
(15 open)
Language Specific 
(121 open)
   Assembly / Machine language 
(15 open)
   ASP 
(65 open)
   ASP .NET 
(72 open)
   C# 
(75 open)
   C++ / C 
(162 open)
   Carbon (Mac OS) 
(5 open)
   Cocoa / Obj-C 
(5 open)
   Cold Fusion 
(11 open)
   Delphi 
(56 open)
   Java 
(102 open)
   JSP 
(21 open)
   Perl 
(47 open)
   Python 
(6 open)
   PHP 
(117 open)
   XML/XSL 
(33 open)
   Visual Basic 
(161 open)
   Visual Basic .Net 
(108 open)
   Other 
(78 open)
Misc 
(48 open)
   Middleware 
(3 open)
   CAD 
(3 open)
MultiMedia 
(28 open)
   Video Editing 
(5 open)
Network 
(34 open)
   Network Design 
(8 open)
   Network Implementation 
(7 open)
Platforms 
(80 open)
   Windows 
(195 open)
     MS Exchange 
(9 open)
     MS Office 
(28 open)
     Other 
(15 open)
   Darwin 
(1 open)
   Embedded Systems 
(16 open)
   Hand Held/PDA Programming 
(21 open)
   Internet Browser 
(47 open)
   Linux 
(63 open)
   Lotus Notes / Domino 
(3 open)
   UNIX 
(33 open)
Requirements 
(16 open)
Security 
(34 open)
Testing / Quality Assurance 
(22 open)
Web 
(171 open)
   Page Design 
(92 open)
   Flash 
(54 open)
   Marketing 
(15 open)
     Search Engine Optimization 
(12 open)
     Marketing (Other) 
(10 open)
   Web Services 
(91 open)
   Web (Other) 
(104 open)
Training 
(16 open)
   Computer Based 
(14 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
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.
 




Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Securenext
Rated a 9.96 on 127 jobs 
Buddies
Rated a 9.86 on 97 jobs 
Codman
Rated a 9.97 on 159 jobs 
hernest
Rated a 10 on 122 jobs 
Andrei Remenchuk
Rated a 10 on 14 jobs 
D-N-S
Rated a 9.93 on 40 jobs 
markesh
Rated a 10 on 24 jobs 
GribFritz
Rated a 9.89 on 158 jobs 
PSergei
Rated a 9.78 on 112 jobs 
ASP.NET
Rated a 9.86 on 62 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.