Using IF EXISTS inside CASE block in SQL

[mayurkashikar]

Hi

Can I use IF EXISTS inside CASE block in SQL (MS SQL SERVER 2000)?
if yes, how??? if you have example, it will help.

Thanks
Mayur

 

[Bob Phillips]

IF EXISTS, is what exists?

SQL queries the database, so if you want only certain items, you use a WHERE
clause.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Rob Bovey]

Hi Mayur,

Since EXISTS returns a boolean result you can potentially use it in the
searched form of the T-SQL CASE function. The example shown below, from one
of my databases, returns a report name and a string indicating whether or
not a benchmark exists for that report in another table.

SELECT r.ReportUniqueName,
CASE
WHEN EXISTS (SELECT ReportID
FROM ReportBenchmarks
WHERE ReportID = r.ReportID)
THEN 'Has Benchmark' ELSE 'No Benchmark' END
FROM Reports AS r

I wouldn't say this is the most efficient way to write the query, but it
does work.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm