This should be the correct syntax for SQL Server:

Code:
update BFCD_Designs set EndDt='20070529'
from BFCD_Designs t1 inner join User_D t2 on t1.DesignId=t2.Design
You can use the IN() example too if you want to.

The reason I'm using the format yyyymmdd is because this is the only format, and the ISO format, without any date separator characters. Let me put it this way; what date is 03/04/05? In U.S format that would be March 4 2005, in French/British it would be April 3 2005 and in Japan April 4 2003. See my point. So use the ISO format yyyymmdd.