?
Solved

sql server 2012 CASE expressions may be used in

Posted on 2012-09-11
1
Medium Priority
?
325 Views
Last Modified: 2012-09-14
Hi experts,

can you give me transact sql code about
CASE expressions may be used in:
WHERE or HAVING clauses
ORDER BY clause
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 9

Accepted Solution

by:
Vijaya Reddy Pinnapa Reddy earned 1400 total points
ID: 38389466
Check this msdn document, explained with examples,
http://msdn.microsoft.com/en-us/library/ms181765.aspx
Also look at the following example,
http://stackoverflow.com/questions/4205012/case-statement-in-having-clause-in-sql
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Screencast - Getting to Know the Pipeline

750 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question