CREATE PROCEDURE [dbo].[estraiCountTicketData] 
  -- Add the parameters for the stored procedure here
  @p1 varchar(50), 
  @p2 varchar(50)
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

    select count(*) as quantiT from tblTicket WHERE dataApertura between @p1 + ' 00:00:00' and @p2 + ' 23:00:00' --'11/02/2007 00:00:00' and '11/02/2007 23:00:00'
END