Hey guys - I want to have a stored proc that returns back the top 'n' number of items that I ask for (rather than hardcoding the value).
i.e. -- create procedure topResults @total numeric select top @total * from myTable RETURN -- However, it really doesn't like the 'top @total' 'incorrect syntax' is all I get. Any way I can do this without resorting to dynamic SQL (either stored proc, or CF side) Cheers, Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
