I want to use an IF statement to check if a SELECT statement returns values. If the SELECT returns values I want to do one thing, and if it does not return any values I want to do another thing.
Something like this:
IF (SELECT * FROM TEMP_TABLE) <> NULL
Do Something Else
My problem is that I can't get the IF statement right.
Can anyone help???
Thanks in advance!