CREATE PROCEDURE spTopProductMonth
(
@ODate datetime
)
AS
SELECT [Order].OID,PID,CID,ODate,[Status],UnitPrice,Amount
from [Order] inner join OrderDetails
on [Order].OID = OrderDetails.OID
WHERE @ODate = ODate;
EXECUTE spTopProductMonth '03/10/2012' ;
I'm make it.. but it's not show when i run...