Show Bid Request SQL2000 Auto Field Increment Bid Request Id: 35115 Bookmark in my 'To Do' list Posted by: mwade (101 ratings) (Software buyer rating 9.96) Non-action Ratio: Very Good - 12.09% Buyer Security Verifications: Excellent Approved on: Nov 12, 2002 3:16:36 PM EDT Bidding Closes: Nov 15, 2002 3:21:20 PM EDT Viewed (by coders): 328 times Deadline: 11/19/2002 TIME EXPIRED Phase: 100% of work was accepted by buyer. Coder account has been credited. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database, SQL Server Enter chat room for this bid request (0 active users at Sep 12, 2003 10:49:19 PM EDT) Description: We are looking to auto increment a field ie 1-10 and if one row is deleted we need the fields to renumber them selfs and when the next row is inserted we need to continue from the next higest number.. We are using the IDENTITY property in Microsoft SQL Server 2000 to auto-increment a field in our database. For example, if you have 10 rows of data this column would have them numbered 1 thru 10. The problem we are having is when a row is deleted the other rows dont renumber and SQL continues from the last number it saved. Here&'s what we are looking for: If you delete one of the rows (for example row 7)…we would like the auto-increment to update the other fields so they are numbered sequentially again (8 moves to the 7 spot, 9 to the 8 spot, and 10 to the 9 spot - so the rows are numbered 1 thru 9). Right now when a row is deleted, it does not update the field…just moves on to the next number. Does anyone have a solution to this problem? 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: Windows Must be 100% finished and received by buyer on: Nov 19, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. 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! ManojRai (1 ratings) in Howrah, West Bengal India Bid id: 387,606   $15 (USD) Nov 14, 2002 3:54:07 AM EDT  10 (Excellent)     1) This type of situation has been handle by me. 2) The code will be provided along with detail documentation. 3) There is a very easy way to handle the same.