Hey All,
Looking for the lingo to do case statements in SQL Server stored procedures.
So I want to mirror this:
<cfif len(qOrderRules.Union_ID)>
AND Sup_Service_Union.Union_ID = #qOrderRules.Union_ID#
AND Sup_Service_Union.Service_ID = Sup_Service.Service_ID
</cfif>
in the WHERE clause of the stored proc. (lets assume I pass a param to the stored proc
called
@Union_ID)
On that note what's the consensus on using case statements like this in stored procs
vs. a different
stored proc for each case?
TIA
Bryan Stevenson
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
p. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
