Dear Experts ,
I would like to do the following :-
get the date out of a certain column in a table
select docdate from tablename
Check if the docdate is greater than todays date, if so display it
I have tried using a while loop but it fails. It just picks one date only instead of all the dates in the table. This does not work
WHILE (SELECT docdate FROM tablename) <> ''
SELECT @BATCH=docdate FROM tablename