Re: Noodling over Switch Statements and Stored Procedures and Eff icie ncy

If you're using MS-SQL 7.0 you may want to consider sp_executesql. From documention: sp_executesql is introduced in Microsoft® SQL Server™ version 7.0. Using sp_executesql is recommended over using the EXECUTE statement to execute a string. Not only does the support for parameter substitution

RE: Noodling over Switch Statements and Stored Procedures and Eff icie ncy

There's your answer...that's the last time I'll use EXEC!!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 17 August 2000 14:50 To: [EMAIL PROTECTED] Subject: Re: Noodling over Switch Statements and Stored Procedures and Eff icie ncy If you're using MS

RE: Noodling over Switch Statements and Stored Procedures and Eff icie ncy

no probs -Original Message- From: Eberhart, Robert D [mailto:[EMAIL PROTECTED]] Sent: 17 August 2000 15:02 To: '[EMAIL PROTECTED]' Subject: RE: Noodling over Switch Statements and Stored Procedures and Eff icie ncy This message is in MIME format. Since your mail reader does