question about a sql server stored procedure

[robdotnet00]

I wrote this and the syntax is fine however when i go to execute it in query analyzer it throws me and error about the '2/7/2003' Any ideas the column with the date is a datetime format

CREATE PROCEDURE dbo.TimesAccessed(@BeginDate datetime,@EndDate datetime) AS
SELECT UserName, location, AccessDate
FROM UserStats
WHERE (AccessDate > @BeginDate) AND (AccessDate <@EndDate )
GO


exec dbo.TimesAccessed('2/7/2003','2/15/2003')

[brucevde]

Get rid of the parenthesis, they are required when executing a literal string or variable, not when passing in parameters.

exec dbo.TimesAccessed '2/7/2003', '2/15/2003'

[robdotnet00]

yep that did it thanks