Show Bid Request
SQL Query Job
Bid Request Id: 7172
|
|
|
Description:
I am looking to have a SQL statement for MS-SQL server 2000 that will basically determine the master id of a group of related records. It is very much like a message thread in a newsgroup.
For example, if record 1 is a master, and record 2 has a field that points to record 1, and record 3 points to record 2, I need to have a SELECT that will have results somthing like this:
id: 1 parent: null id: 2 parent: 1 id: 3 parent: 1
It is basically a message list, where record 1 is the first post, record 2 is a reply to it, and record 3 is a reply to the reply, but I need to be able to determine the Original post id.
Ideally this will be a stored procedure or something. If this is unclear let me know and I can provide more information.
Deliverables: Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
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!
|
$30 (USD)
|
Jan 4, 2002 2:23:56 PM EDT
|
9.78
(Excellent)
|
|
|
I can do this for you I have 3+ years of experience in Databases
Regards Coder |
|
|
|
|
|