CREATE PROCEDURE `FetchSupplierByRequest`(intConferenceId int, intRank int,intTableNo int) BEGIN SELECT Distinct c.ID , c.CompanyName, c.Type FROM conferencetabletop cp, companies c, meeting m WHERE cp.ConferenceID = intConferenceId AND c.ID = m.SupplierID and m.AgendaID=cp.ConferenceId and m.Rank=intRank ORDER BY m.CreatedDate DESC LIMIT 0, intTableNo; END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)