select
CodStruttura,
Codcomune,
NomeStruttura,
Telefono,
dataupdate=(SELECT MAX(CASE WHEN DataArrivo>= IsNull(DataPartenza,'19000101') THEN DataArrivo ELSE DataPartenza END) FROM dbo.Archivio_mov_new Where codalbergo=Albergo.CodStruttura and codcomalbergo=Albergo.codcomune
and dataarrivo between @data1 and @data2 and IsNull(DataPartenza,'19000101') <= @data2 and DataUpdate Is Null)
from Albergo