[cfaussie] Re: [OT] SP Issue (Datediff)

[Taco Fleur]

Never mind! Got it..   1. UPDATE  thisTable 3.    expiryDate = DATEADD(minute, DATEDIFF(minute, startDate, expiryDate)/2, GETDATE()) 2. SET   startDate = DATEADD(minute, DATEDIFF(minute, startDate, expiryDate), GETDATE()),  4. WHERE  (pkAuctionID IN (' + @lstAuctionID + ')) '   Notice, line 3 is now line 2 and added a division of 2... ----- Original Message ----- From: Taco Fleur To: CFAussie Mailing List Sent: Sunday, March 23, 2003 5:52 PM Subject: [cfaussie] [OT] SP Issue (Datediff) Hi,   I have this Stored Procedure that basically relists an action when it is finished   1. UPDATE  thisTable 2. SET   startDate = DATEADD(minute, DATEDIFF(minute, startDate, expiryDate), GETDATE()), 3.    expiryDate = DATEADD(minute, DATEDIFF(minute, startDate, expiryDate), GETDATE()) 4. WHERE  (pkAuctionID IN (' + @lstAuctionID + ')) '   The problem comes in on line 2 and 3, obviously when the Startdate (line 2) is updated with the new value then on line 3 there is no difference in time anymore. The only way I think I can overcome this issue is by using a CURSOR, but I would like to do it without a CURSOR if possible.   Example: Before update startDate                                expiryDate 23/03/2003 17:00 AM                23/03/2003 17:10 AM After update 23/03/2003 17:10 AM                23/03/2003 17:10 AM While the result I want is 23/03/2003 17:10 AM                23/03/2003 17:20 AM   Anyone? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/