C
CQ
It was suggested I post this in the Developer side:
I have an interesting one. I need to select the most recent baseline (yes,
we can use all 11) and put it into one field. I need to do it in SQL. I
have struggled with an IIF statement, a CASE statement and I can't seem to
figure it out. For every task on every project, I need to basically go
through each baseline starting with the finish date for baseline 10 and if it
is null, then go to baseline 9, etc. on down until I hit one that isn't null,
and then select that one. Once I have selected one, I can move on to the
next task. Thoughts?
I have an interesting one. I need to select the most recent baseline (yes,
we can use all 11) and put it into one field. I need to do it in SQL. I
have struggled with an IIF statement, a CASE statement and I can't seem to
figure it out. For every task on every project, I need to basically go
through each baseline starting with the finish date for baseline 10 and if it
is null, then go to baseline 9, etc. on down until I hit one that isn't null,
and then select that one. Once I have selected one, I can move on to the
next task. Thoughts?