Using IF EXISTS inside CASE block in SQL

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

 

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)

 

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