Need BOOLEAN Result from SQL EXISTS Statement without using a WHERE Clause

sql-server tsql exists
blarson picture blarson · Jun 15, 2012 · Viewed 25.8k times · Source

Is there any way in a simple query to return a Boolean value using an SQL EXISTS statement without using a WHERE clause?

All of the 2008 R2 SQL Server Books Online examples show another WHERE clause and two tables. Website examples show either a WHERE or an IF-THEN-ELSE in a procedure.

I was hoping to do the following on one table:

EXISTS
(SELECT  cx.id
 FROM fdd.admissions_view as cx  
 WHERE cx.id=1111 and cx.campus='MEXI')

The SELECT statement works fine and returns the ID. I just want to add EXISTS to return a BOOLEAN, but the syntax above is not valid.

Can I do something like this? If so, what am I missing syntax-wise? If not, what other technique may work?

Please advise. Thanks.

Answer

500 - Internal Server Error picture 500 - Internal Server Error · Jun 15, 2012

How about something like

select case when count(cx.id) > 0 then 1 else 0 end 
 FROM fdd.admissions_view as cx  
 WHERE cx.id=1111 and cx.campus='MEXI'

?

Related questions

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

My query is as follows, and contains a subquery within it: select count(distinct dNum) from myDB.dbo.AQ where A_ID in (SELECT DISTINCT TOP (0.1) PERCENT A_ID, COUNT(DISTINCT dNum) AS ud FROM myDB.dbo.AQ WHERE M &…

Read More
How to exclude records with certain values in sql select

How do I only select the stores that don't have client 5? StoreId ClientId ------- --------- 1 4 1 5 2 5 2 6 2 7 3 8 I'm trying something like this: SELECT SC.StoreId FROM StoreClients INNER JOIN StoreClients SC ON StoreClients.StoreId = SC.StoreId WHERE SC.ClientId = 5 GROUP BY StoreClients.…

Read More
IF EXISTS in T-SQL

If we have a SELECT statement inside an IF EXISTS, does the execution stop as soon as it finds a record in the table? For example: IF EXISTS(SELECT * FROM table1 WHERE Name='John' ) return 1 else return 0 If a row …

Read More