I know what you mean about email delay! Sometimes I just feel like a fool on this list, 40 people gave an answer to a simple question and then my answer comes in...
-----Original Message----- From: Theo Galanakis [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 June 2004 4:54 PM To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] MS SQL Stored Proc Question My email was delayed somewhat! However we where thinking along the same lines. Unfortunately I don't know of another way to query a XML string other than OPENXML(). It's not really that cumbersome in the end! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Taco Fleur Sent: Friday, 4 June 2004 6:54 PM To: CFAussie Mailing List Subject: [cfaussie] Re: [OT] MS SQL Stored Proc Question 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 This message may contain privileged or confidential information and is intended only for the individual named. If you are not the named addressee you should not disclose, disseminate, distribute or copy this e-mail. If you have received this e-mail by mistake please notify the sender immediately by e-mail and delete this e-mail from your system. You should rely on your own virus checking programmes and procedures for checking any attachments. Please advise us if you wish your name and e-mail address to be removed from our database. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ 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] Aussie Macromedia Developers: http://lists.daemon.com.au/
