<div>
Something like this?<br />
<br />
Lee<br />

<pre><code id="code-8097649">if EXISTS (select top 1 * from tab2 where tab1.col1 = tab2.col1)
    select 'Y'
else
    select 'N'</code></pre>
</div>


Something like this?

Lee


if EXISTS (select top 1 * from tab2 where tab1.col1 = tab2.col1)
    select 'Y'
else
    select 'N'

<div>
<div class="content wysiwyg-content">
What would be a good way to make this logic work in a SQL query?<br />
<br />
select col1, col2, col3, YorN<br />
from tab1<br />
<br />
I want to return YorN as either a literal 'Y' or 'N' based on whether or not something EXISTS or not. <br />
<br />
if EXISTS (select 1 from tab2 where tab1.col1 = tab2.col1) then Y<br />
if NOT EXISTS (same as above) then select N<br />
<br />
What's the most efficient way of doing this?
</div>
</div>


What would be a good way to make this logic work in a SQL query?

select col1, col2, col3, YorN
from tab1

I want to return YorN as either a literal 'Y' or 'N' based on whether or not something EXISTS or not. 

if EXISTS (select 1 from tab2 where tab1.col1 = tab2.col1) then Y
if NOT EXISTS (same as above) then select N

What's the most efficient way of doing this?

return Y or N based on result of EXISTS subquery

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.