Show Bid Request Change of state Bid Request Id: 960 Bookmark in my 'To Do' list Posted by: jjapol (3 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Buyer Security Verifications: Unverified Approved on: Jul 21, 2001 2:51:40 PM EDT Bidding Closes: Jul 23, 2001 10:00:00 AM EDT Viewed (by coders): 630 times Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database Enter chat room for this bid request (0 active users at Sep 25, 2003 9:00:06 AM EDT) Description: Write a query for MSQuery in SQL that will filter a table for the first occourance of a value and ignore the consecutive equal values of that value. The best way that I can explain it is that I need to know when values change state. See the attached example table and desired results. I am working in Excel and using MS Query to query a database. Deliverables: SQL code that will produce the results shown in my example. Additional Files: This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding. 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   dcoragem (9 ratings) in Reguengos, Alentejo Portugal Bid id: 9,967   N/A Jul 21, 2001 7:15:16 PM EDT  10 (Excellent)     Hi there! I'm not placing a bid, but if this SQL Statement is what you need, please, feel free to retribute my contribution (the $50 would be nice :-) ) Here's your SQL instruction: Select Tag, Min(Time) as Time, Value From Table Group By Tag, Value Domingos Coragem This bid was accepted by the buyer! dcoragem (9 ratings) in Reguengos, Alentejo Portugal Bid id: 10,128   $50 (USD) Jul 23, 2001 12:14:16 PM EDT  10 (Excellent)     Hi! I'll do it. Domingos Coragem