The first two work but they just return the column header.

Somehow we are not selecting(*) in the first line of the statement.

Many many thanks for your efforts so far.

This is the error I get on the last line

Select create_time

From ticket_history

WHERE create_time >= @BeginningDate

and create_time < DATEADD(DD, 1, @BeginningDate)

TITLE: Microsoft SQL Server Report Builder

------------------------------

An error occurred while executing the query.

ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10]FUNCTION otrs.DATEADD does not exist

------------------------------

ADDITIONAL INFORMATION:

ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.41-3ubuntu12.10]FUNCTION otrs.DATEADD does not exist (myodbc3.dll)

------------------------------

BUTTONS:

OK

------------------------------

Cheers!