执行存储过程出错？

[sagegz]

/*CREATE PROCEDURE SP_ShowLeaveSummary
@start DATETIME,
@end DATETIME
AS
BEGIN
SELECT a.EmployeeID,a.EmployeeName,ISNULL(b.LeaveCount,0) LeaveCount,
ISNULL(b.LeaveTotalHours,0) LeaveTotalHours,a.ALhours,DeptID
FROM TBL_EmployeeInfo a
LEFT JOIN (SELECT EmployeeID,COUNT(1) LeaveCount,SUM(Hours) LeaveTotalHours 
FROM TBL_LeaveInfo WHERE StartTime > @start AND EndTime < @end GROUP BY EmployeeID) b
        ON a.EmployeeID=b.EmployeeID
END*/
EXECUTE SP_ShowLeaveSummary('2010/7/6','2010/7/7');

提示信息：
消息 102，级别 15，状态 1，第 78 行
'2010/7/6' 附近有语法错误。
怎么改呢？

[永生天地]

ECUTE SP_ShowLeaveSummary '2010/7/6','2010/7/7'

[永生天地]

exec SP_ShowLeaveSummary '2010/7/6','2010/7/7'

[Zoezs]

看你少了几个逗号。

CREATE PROCEDURE SP_ShowLeaveSummary
@start DATETIME,
@end DATETIME
AS
BEGIN

SELECT a.EmployeeID,a.EmployeeName,ISNULL(b.LeaveCount,0),LeaveCount,
	ISNULL(b.LeaveTotalHours,0),LeaveTotalHours,a.ALhours,DeptID
FROM TBL_EmployeeInfo a
LEFT JOIN (SELECT EmployeeID,COUNT(1) LeaveCount,SUM(Hours) LeaveTotalHours 
			FROM TBL_LeaveInfo WHERE StartTime > @start AND EndTime < @end GROUP BY EmployeeID) b
ON a.EmployeeID=b.EmployeeID

END