I Am Trying To Move From Access Db To Sql.s

hello

i am trying to move from Access db to Sql.s



could you please what is rwong in the sql.s syntax:



------Access SP:----------

PARAMETERS [@Date_M_Y] DateTime, [@BIZID] Long;
SELECT SUM(MINUTE(Time_)) AS MM, SUM(HOUR(Time_)) AS HH, COUNT(Date_) AS SHIFTS, SUM(Money_Sum) AS MONEY_TOTAL, AVG(Money_Sum) AS AVG_MONEY_PER_SHIFT
FROM TblTimeSum
WHERE MONTH(Date_)=MONTH([@Date_M_Y]) And YEAR(Date_)=YEAR([@Date_M_Y]) And BIZID=[@BIZID];


----- SQL.S----

CREATE PROCEDURE SP_SUM

@Date_M_Y smalldatetime,

@BIZID int



AS

BEGIN

SELECT SUM(MINUTE(Time_)) AS MM, SUM(HOUR(Time_)) AS HH, COUNT(Date_) AS SHIFTS, SUM(Money_Sum) AS MONEY_TOTAL, AVG(Money_Sum) AS AVG_MONEY_PER_SHIFT

FROM TblTimeSum

WHERE MONTH(Date_)=MONTH([@Date_M_Y]) And YEAR(Date_)=YEAR([@Date_M_Y]) And BIZID=[@BIZID]

END

GO





thanks