Will this work
DECLARE @some var
SELECT *
FROM MY_FAKE_TABLE
WHERE @some var = CASE
WHEN @some var = 'A' THEN @ARGUMENT_A
WHEN @some var = 'B' THEN @ARGUMENT_B
ELSE @ARGUMENT_DEFAULT
END
Thanks
Scott
Scott A. Stewart
Webmaster/ Developer
GlobalNet Services, Inc
http://www.gnsi.com
11820 Parklawn Dr
Rockville, MD 20852
Voice: (301) 770-9610 x 335
Fax: (301) 770-9611
The information contained in this message may be privileged, confidential,
and protected from disclosure. If the reader of this message is not the
intended recipient, or any employee or agent responsible for delivering this
message to the intended recipient, you are hereby notified that any
dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this communication in error, please notify
us immediately by replying to the message and deleting it from your
computer.
-----Original Message-----
From: Chris Stoner [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 12:51 PM
To: CF-Community
Subject: Re: SQL Question, Switch Case
Or to more directly tie in with your question:
SELECT *
FROM MY_FAKE_TABLE
WHERE FAKE_COLUMN = CASE
WHEN FAKE_COLUMN_2 = 'A' THEN @ARGUMENT_A
WHEN FAKE_COLUMN_2 = 'B' THEN @ARGUMENT_B
ELSE @ARGUMENT_DEFAULT
END
On 3/31/06, Chris Stoner <[EMAIL PROTECTED]> wrote:
>
> Yes to a point...such as you can do something like my example below (not
> tested,obviously). The issue you will run into is that you wont be able
to
> have a where clause with multiple filters. You basically can use the case
> statement to equate a specific column to another column depending on the
> condition.
>
> SELECT *
> FROM MY_FAKE_TABLE
> WHERE FAKE_COLUMN = CASE
> WHEN FAKE_COLUMN_2 = 'A' THEN FAKE_COLUMN_3
> WHEN FAKE_COLUMN_2 = 'B' THEN FAKE_COLUMN_4
> ELSE FAKE_COLUMN_5
> END
>
>
>
>
> On 3/31/06, Scott Stewart <[EMAIL PROTECTED]> wrote:
> >
> > All,
> >
> >
> >
> > Can you use a switch case statement to build a dynamic where clause
> > based on
> > parameters passed to a stored procedure?
> >
> > I'm using T-SQL in SQLServer 2000
> >
> >
> >
> > IE:
> >
> >
> >
> > Case where entity_type is X
> >
> > "piece of where clause"
> >
> > Case where enity_type is Y
> >
> > "piece of where clause"
> >
> >
> >
> > Thanks
> >
> >
> >
> > Scott
> >
> >
> >
> > Scott A. Stewart
> >
> > Webmaster/ Developer
> >
> > GlobalNet Services, Inc
> >
> >
> >
> > <http://www.gnsi.com> http://www.gnsi.com
> >
> > 11820 Parklawn Dr
> >
> > Rockville, MD 20852
> >
> > Voice: (301) 770-9610 x 335
> >
> > Fax: (301) 770-9611
> >
> >
> >
> > The information contained in this message may be privileged,
> > confidential,
> > and protected from disclosure. If the reader of this message is not the
> > intended recipient, or any employee or agent responsible for delivering
> > this
> > message to the intended recipient, you are hereby notified that any
> > dissemination, distribution, or copying of this communication is
> > strictly
> > prohibited. If you have received this communication in error, please
> > notify
> > us immediately by replying to the message and deleting it from your
> > computer.
> >
> >
> >
> >
> >
> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:202432
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
