Unanswered: Assign Column Name in CASE Statement
Call me stupid (no, please), but forgot how to assign a name to an output column in this CASE statrement:
WHEN COALESCE(Length(AIM.AIMRETRIEVEDITEM.ImageFront), 0) = 0
THEN 2 --AS --'AVAILABLEFLAG'
ELSE 1 --AS --'AVAILABLEFLAG'
I'm so ashamed...
"If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."