WayneS (6/28/2010)

---

I would suggest the following:

declare @MyDate datetime,

@fn varchar(100),

@cmd varchar(200)

set @MyDate = DateAdd(day, -1,...