Bob-683340 (10/13/2011)

---

So which is really better - the very clever one-liner whose logic can't be unravelled without some head scratching, or the somewhat longer version that's simple enough to be self-explanatory?

[font="Courier New"]select @TargetDate = dateadd(dd,@DaysOut,@StartDate)

while datepart(dw,@TargetDate) <> @DesiredDayOfWeek

set @TargetDate = @TargetDate + 1[/font]