Should this line: WHERE MenuID = (SELECT MenuID FROM Fuseactions WHERE fuseaction = @fuseaction)
Maybe read: WHERE MenuID IN (SELECT MenuID FROM Fuseactions WHERE fuseaction = @fuseaction) ? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- "Allan Cliff" <[EMAIL PROTECTED] To: "CF - List" <[EMAIL PROTECTED]> .net> cc: Subject: [ cf-dev ] Stored Procedures 17/10/2003 10:05 Please respond to dev Any ideas why this SP doesn't work? I have only used simple SPs before. If I remove the subquery then it returns results. Can't you use subqueries in SPs like this, if not what is the solution. Thanks Allan ---------------------------------------------------------------------------- CREATE PROC dbo.sp_GetMenu @fuseaction varchar AS SELECT * FROM Fuseactions WHERE MenuID = (SELECT MenuID FROM Fuseactions WHERE fuseaction = @fuseaction) ORDER BY MenuOrder GO -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
