Re^2: find difference in dates/items in same column

Thanks, unfortunately its more complicated...

The SELECT datediff() is fine for finding ages from a fixed date but not for finding deltas between dates in the same column. Datediff can be used in SQL but then it begins to look like the SQL example and takes ages to run on my 120,000 records with about ~10,000 brands.

Comment on Re^2: find difference in dates/items in same column

Replies are listed 'Best First'.
Re^3: find difference in dates/items in same column by ccn (Vicar) on Nov 14, 2008 at 10:44 UTC
I think there is no better way than you have choosen already. All that I can suggest is cosmetic improvements only.	[reply]
Re^4: find difference in dates/items in same column by Anonymous Monk on Nov 14, 2008 at 10:55 UTC
Thanks, now I see your meaning - that does indeed simplify the date difference code tremendously. However, its the delta between dates in the same column that are the challenge! Thanks for your pointers - I'm sure the code could benefit from plenty of cosmetic surgery !	[reply]