> Typically, when you're building SQL on the fly, you'll have to build a > string, then use EXECUTE (in SQL 6.5) or sp_executesql (in SQL 7 or 2000) to > execute the string. sp_executesql will gain you something in terms of optimization, etc. but this isn't the kind of thing that ought to be in an sp (unless you're doing this for security or management reasons). i might use cf if nothing was being returned & the sql executed quickly enough or use cf to write the sql & then run the whole thing on the db box. DTS is another thing you might look at. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
- Stored Procedures - Am I going insane? Philip Arnold - ASP
- Re: Stored Procedures - looping over selects Deanna L. Schneider
- Re: Stored Procedures - Trying Again Deanna L. Schneider
- Re: Stored Procedures - Am I going insane? Paul Hastings
- RE: Stored Procedures - Am I going insane? Jeremy Allen
- RE: Stored Procedures - Am I going insane? Dave Watts
- Re: Stored Procedures - Am I going insane? Paul Hastings
- Re: Stored Procedures - Am I going insane... Deanna L. Schneider
- Re: Stored Procedures - Am I going in... G
- Re: Stored Procedures - Am I going in... Paul Hastings
- RE: Stored Procedures - Am I goi... Keith Thornburn
- Re: Stored Procedures - to use o... Deanna L. Schneider
- Re: Stored Procedures - to u... Paul Hastings
- RE: Stored Procedures - Am I going insane? Rich Wild
- Re: Stored Procedures - Am I going insane? Paul Hastings
- NT4 SP 6a Keith Thornburn
- RE: Stored Procedures - Am I going insane... Philip Arnold - ASP