Update Items Set DTS = cast('12/30/2016' as datetime) 
where ContentID in(select ContentID from  Contents where Type = 0)