<div>
p.s. The results should look something like:<br />
<br />
FK_ID &nbsp; Total &nbsp; &nbsp;Rejected &nbsp; Reviewed<br />
1234 &nbsp; &nbsp;6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5
</div>


p.s. The results should look something like:

FK_ID   Total    Rejected   Reviewed
1234    6          1             5

<div>
SELECT 'Total', COUNT(*) FROM table WHERE FK_ID=x<br />
UNION ALL<br />
SELECT 'REVIEWED',COUNT(*) FROM table WHERE FK_ID=x AND REVIEWED=1<br />
UNION ALL<br />
SELECT 'REJECTED',COUNT(*) FROM table WHERE FK_ID=x AND REJECTED=1<br />
<br />

</div>


SELECT 'Total', COUNT(*) FROM table WHERE FK_ID=x
UNION ALL
SELECT 'REVIEWED',COUNT(*) FROM table WHERE FK_ID=x AND REVIEWED=1
UNION ALL
SELECT 'REJECTED',COUNT(*) FROM table WHERE FK_ID=x AND REJECTED=1



<div>
I just had to swap the Reviewed and Rejected expression labels and works like a charm.<br />
Thanks!
</div>


I just had to swap the Reviewed and Rejected expression labels and works like a charm.
Thanks!

<div>
lol - tired eyes. Must be bed time ;)<br />
<br />
Glad to help.
</div>


lol - tired eyes. Must be bed time ;)

Glad to help.

<div>
<div class="content wysiwyg-content">
I &nbsp;have a table with the following fields<br />
<br />
FK_ID - foriegn key ID<br />
PK_ID - unique PK <br />
REVIEWED - bit<br />
REJECTED - bit<br />
<br />
I would like a query that, for a particular FK_ID value, returns a count of:<br />
<br />
a. total number of rows matching the FK_ID<br />
b. total number of rows matching the FK_ID that have REVIEWED=1<br />
c. total number rows matching the FK_ID that have REJECTED=1<br />
<br />
I'm sure the answer is already out there but a search didn't find this specific case.<br />
<br />
Thanks,<br />
<br />
Tim
</div>
</div>


I  have a table with the following fields

FK_ID - foriegn key ID
PK_ID - unique PK 
REVIEWED - bit
REJECTED - bit

I would like a query that, for a particular FK_ID value, returns a count of:

a. total number of rows matching the FK_ID
b. total number of rows matching the FK_ID that have REVIEWED=1
c. total number rows matching the FK_ID that have REJECTED=1

I'm sure the answer is already out there but a search didn't find this specific case.

Thanks,

Tim

Query to get total counts of multiple bit fields in each row

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.