ALTER PROCEDURE [dbo].[stampe_New] 
(
@Codalbergo Int,
@CodComAlbergo Int,
@DataArrivo Smalldatetime=Null,
@DataPartenza Smalldatetime=Null,
@data1 SmallDateTime=Null,
@data2 SmallDateTime=Null,
@TypeReport Int
)
AS
If @TypeReport=0  --Stampa totale arrivi e presenze di un periodo
BEGIN
Select count(dataarrivo) As totarrivi 
From Archivio_mov_new
Where 
codalbergo=@codalbergo and
codcomalbergo=@codcomalbergo And
dataarrivo between @data1 and @data2

Select Sum(dbo.GetGGpresenze(dataarrivo,IsNull(datapartenza,dbo.GetLastDateOfMounth(dataarrivo))))as totpresenze 
From Archivio_mov_new
Where 
codalbergo=@codalbergo and
codcomalbergo=@codcomalbergo And
dataarrivo between @data1 and @data2
END