Show Bid Request Find The Earliest Date From Several Columns Bid Request Id: 19668 Bookmark in my 'To Do' list Posted by: unclejohn (4 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 0.00% Posted: Jun 20, 2002 9:00:24 PM EDT Bidding Closes: Jul 2, 2002 9:02:44 PM EDT Viewed (by coders): 269 times Deadline: 7/4/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Personal Project / Homework Help Bidding Type: Open Auction Categories: Windows, Database, Other Enter chat room for this bid request (0 active users at Jun 29, 2003 3:38:41 AM EDT) Description: Looking for a t-sql statement (or view) that will do something very specific. This t-sql statement will find the earliest date from 3 columns in every record of a table. I have three date columns in a database. For every record, I need the sql statement to pick the earliest date and insert that value into a new column. To make this task even trickier, the three date columns will contain null values. I need the T-sql to ignore the null values. As an example: a field called date1 has a value of 4/22/98 a field called date2 has a value of 5/16/92 a field called date3 has a null value I&'m looking for a t-sql statement (or view) that will take the earliest date value from each record in a table and insert that value into new field called date4. Result for the above record….date4=5/16/92 Any suggestions are helpful. 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. Platform: SQL Server 2000--T-SQL Must be 100% finished and received by buyer on: Jul 4, 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! Oleg21 (40 ratings) in Kazan, Tatarstan Russian Federation Bid id: 216,595   $20 (USD) Jun 21, 2002 12:01:00 AM EDT  9.95 (Excellent)     I have 10 years in software development, certified by Microsoft. Not a complicated task, I have already the solution. You can trust me; everyone rated me 10 so far. Sincerely Oleg           See 1 private reply(ies) to/from Oleg21.