Pardeep....yer obviously not getting the answer here....so I went to Google...first result has your answer:
searched for "conditional stored procedure MS SQL" Read the forum posts...I'd us the example with 3 conditions with 3 different queries depending on the condition that is met. I've used this approach before and it works flawlessly....the benfit is explained near the bottom of the page (better use of indexes). The example is not exactly like your...but it shows how to construct the stored proc. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "SQL" <[email protected]> Sent: Thursday, February 24, 2005 11:33 AM Subject: Re: How do you do an IF condition in where statement > No buddy, how do you do it in TSQL for a stored procedure:) > > > ----- Original Message ----- > From: "Venable, John" <[EMAIL PROTECTED]> > To: "SQL" <[email protected]> > Sent: Thursday, February 24, 2005 11:24 AM > Subject: RE: How do you do an IF condition in where statement > > >> You need single quotes around your values. >> >> i.e. lastname='#form.lastname#' >> >> John Venable >> >> > -----Original Message----- >> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> > Sent: Thursday, February 24, 2005 2:26 PM >> > To: SQL >> > Subject: How do you do an IF condition in where statement >> > >> > How would you write this regular Cold Fusion query in TSQL for a >> > stored >> > procedure: >> > >> > select * >> > from profiles >> > where 0=0 >> > <cfif form.firstname neq ''>and >> > firstname=#form.firstname#</cfif> <cfif form.lastname neq ''>and >> > lastname=#form.lastname#</cfif> <cfif form.phone neq ''>and >> > phone=#form.phone#</cfif> >> > >> > I tried a few times, I can't quite get the hang of IF statements in >> > TSQL for some reason, even tho. in CFMX they're juz a piece of cake. >> > >> > Thanks, >> > Pardeep. >> > >> > >> > >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2173 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
