Steve - Could this be across a transaction?
'The Transact-SQL programming language provides several SET statements that alter the current session handling of specific information.' So it would span across a transaction, as that is a 'current session'. Haven't tested it - but it would make sense. Mark -----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
