Re: how to set the execution for specified number of rows in stored procedures

[ujvala ujvala]

hi
thanx. i had checked the limit clause and it worked. here i have a problem with a stored procedure. i tried to migrate stored procedures from northwind database from sql server to mysql but given stored procedure is not executing.

the following is the stored procedure creation:


CREATE PROCEDURE `northwind_dbo`.`Employee Sales by Country`(beginning_date datetime, ending_date datetime)
SELECT `northwind_dbo`.`Employees`.Country, `northwind_dbo`.`Employees`.
LastName, `northwind_dbo`.`Employees`.FirstName, `northwind_dbo`.`Orders`.
ShippedDate, `northwind_dbo`.`Orders`.OrderID, `northwind_dbo`.
`Order Subtotals`.Subtotal
AS SaleAmount
FROM `northwind_dbo`.`Employees` INNER JOIN
(`northwind_dbo`.`Orders` INNER JOIN `northwind_dbo`.`Order Subtotals`
ON `northwind_dbo`.`Orders`.OrderID = `northwind_dbo`.
`Order Subtotals`.OrderID)
ON `northwind_dbo`.`Employees`.EmployeeID = `northwind_dbo`.`Orders`.
EmployeeID
WHERE `northwind_dbo`.`Orders`.ShippedDate
Between @Beginning_Date And @Ending_Date$$


the call statment what i've used in mysql is

CALL `northwind_dbo`.`Employee Sales by Country`(@Beginning_Date='1996-01-01', @Ending_Date='1999-01-01') #this displays 0 rows fetched.

in sql server, the execution query what i've used is :

exec "employee sales by country" @beginning_date='01/01/1996', @ending_date='01/01/1999';
and it worked.

note: since, it uses some other tables and views in the same database, i also checked those objects. all the objects that tie up with this stored procedure are working properly.
but only the stored procedure is not giving the o/p.

can anyone come up with solution for this problem

thanx in advance

UJVALA