Viewing 2 posts - 1 through 3 (of 3 total)
Oh. You are correct. I didn't test :-
The answer would be:
SELECT TOP 1 * FROM #temp WHERE ValidFrom < = getdate() AND ProductCode = '123'
ORDER BY ValidFrom...
April 10, 2016 at 5:34 am
#1871005
SELECT TOP 1 * FROM #temp WHERE ValidFrom > getdate() ORDER BY ValidFrom ASC
April 6, 2016 at 3:05 am
#1870075