declare @rr int set @rr=0 select @rr= COUNT(dataarrivo) from TabMovimenti_1 where dataarrivo <'10/02/2012' and (datapartenza is null or datapartenza <'10/02/2012')