Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2001-10-29 : 08:08:23
|
| Hi,I want to find the closest date.In my database i have two dates1. Expected Delivery Date (Buyer)2. Offered Delivery Date (Seller)Now, a buyer wants a shipment on say 11/12/2001 (mm/dd/yyyy)One seller Offers SellerName DateA 11/11/2001B 11/14/2001C 11/01/2001D 11/18/2001Then the SP should return 11/11/2001If some seller offers sayE 13/11/2001Here the the datedifference od Seller A and E is same, then in this case SP Should return A(The earlier one.)Is it possibleThanx in Advance---------------------------Sandesh - The Messanger |
|
|
|
|
|
Closest Date