<div>
IF exists( SELECT active from dbo.user where active ='1') <br />
BEGIN<br />
PRINT 'YES'<br />
Select active from dbo.user where active = '1'<br />
END<br />
ELSE<br />
IF exists(Select active from dbo.user where active ='0') <br />
BEGIN<br />
PRINT 'NO'<br />
END
</div>


IF exists( SELECT active from dbo.user where active ='1')
BEGIN
PRINT 'YES'
Select active from dbo.user where active = '1'
END
ELSE
IF exists(Select active from dbo.user where active ='0')
BEGIN
PRINT 'NO'
END

<div>
Thanks so much. It was so much easier then expected!
</div>


Thanks so much. It was so much easier then expected!

<div>
<div class="content wysiwyg-content">
I am new to T-SQL and am using reporting services to create reports from the database. However, the database shows a field called Active as 1 or 0. I want it to say Yes if 1 is shown and No if 0 is shown. I dont want to update the database to Yes or No but keep that 1/0 although when i want to report that field, i want to show Yes/no<br />
<br />
This is my query as of now.<br />
<br />
IF ( SELECT active from dbo.user where active ='1') = '1'<br />
BEGIN <br />
PRINT 'YES' <br />
Select active from dbo.user where active = '1'<br />
END <br />
ELSE<br />
IF (Select active from dbo.user where active ='0') ='0'<br />
BEGIN<br />
PRINT 'NO' <br />
END<br />
<br />
The Error says - MSG 512 Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,... or when the subquery is used as an expression.<br />
<br />
I am sorry as i am new to this and probably have it all wrong. Please advice it will be greatly appreciated.
</div>
</div>


I am new to T-SQL and am using reporting services to create reports from the database. However, the database shows a field called Active as 1 or 0. I want it to say Yes if 1 is shown and No if 0 is shown. I dont want to update the database to Yes or No but keep that 1/0 although when i want to report that field, i want to show Yes/no

This is my query as of now.

IF ( SELECT active from dbo.user where active ='1') = '1'
BEGIN 
PRINT 'YES' 
Select active from dbo.user where active = '1'
END 
ELSE
IF (Select active from dbo.user where active ='0') ='0'
BEGIN
PRINT 'NO' 
END

The Error says - MSG 512 Subquery returned more than 1 value. This is not permitted when the subquery follows =,!=,... or when the subquery is used as an expression.

I am sorry as i am new to this and probably have it all wrong. Please advice it will be greatly appreciated.

Simple IF...Else Statement to convert 1/0 to Yes/No

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.