Hello
I am having the exact same issuse and changing the order is not helping me...
Summary of the problem:
SELECT a,b,c,, getdate() -90 AS defaultstartdate, getdate()-60 AS defaultenddate
FROM x,y,z
WHERE x.date BETWEEN @startdate AND @enddate
@startdate and @enddate are setup as date/time with defualt values of defaultstartdate and defaultenddate respectively....
I am getting the "Forward dependencies are not valid." errors...
PLEASE HELP!!!
Thanks
MAX