Is this within one stored procedure? Or different calls to the db? I never experienced this with multiple calls to the db, it should only persist during one request..
Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Steve Onnis > Sent: Friday, 4 June 2004 5:05 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: [OT] MS SQL Stored Proc Question > > > Has anyone has problems with SET ROWCOUNT persisting across queries? > > I have had issues where is i do a SET ROWCOUNT on a query, it > then persists across all my other queries > > Steve > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Taco Fleur > Sent: Friday, June 04, 2004 4:44 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: [OT] MS SQL Stored Proc Question > > > > yup very cool... > > -----Original Message----- > From: Scott Thornton [mailto:[EMAIL PROTECTED] > Sent: Friday, 4 June 2004 4:39 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: [OT] MS SQL Stored Proc Question > > > Hi, > > Use > > SET ROWCOUNT @PARAMETER > > eg > > create procedure Test > ( > @PARAMETER int > ) > as > > SET ROWCOUNT @PARAMETER > > select * from wherever > > -- EXECUTE Test 10, will return 10 records. > go > > cool huh? :-) > > > set rowcount 0 will of course return ALL records. > > Have a good weekend all!. > > > > > > Scott Thornton, Programmer > Application Development > Information Services and Telecommunications > Hunter Area Health Service > Phone +61 2 49214193 > Fax +61 2 49214191 > > [EMAIL PROTECTED] > > >>> [EMAIL PROTECTED] 4/06/2004 4:20:04 pm >>> > 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 --- 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 Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf --- 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 --- 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 --- 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
