thanks,
it works

julia...

Hi everyone,
I'm trying to create a stored procedure that has two datetime arguments and would like to assign default values to them,
I tried using CURRENT_TIMESTA MP or GETDATE(), but must have some syntax problems, hope you can help me:

CREATE PROCEDURE getReportByDate Range
@firstDate DATETIME = GETDATE(),
@secondDate DATETIME = GETDATE()...