<div>
select count(*)<br />
from ( select kitlot from yourtable group by kitlot where instrument = 1 ) as subquery<br />
<br />
<br />
for all instruments:<br />
<br />
select instrument, count(*)<br />
from ( select instrument, kitlot from yourtable group by instrument, kitlot &nbsp;) subquery<br />
group by instrument<br />
<br />
<br />

</div>


select count(*)
from ( select kitlot from yourtable group by kitlot where instrument = 1 ) as subquery


for all instruments:

select instrument, count(*)
from ( select instrument, kitlot from yourtable group by instrument, kitlot  ) subquery
group by instrument




<div>
Perfect Thanks a ton and just in time for my 9:30 meeting :)
</div>


Perfect Thanks a ton and just in time for my 9:30 meeting :)

<div>
<div class="content wysiwyg-content">
Hello I have a table in MS SQL Server that looks like this<br />
<br />
Instrument, &nbsp;KitLot<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Z123<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Z123<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; U101<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; U101<br />
<br />
I would want to know how many unique &nbsp;kitLots there are &nbsp;per instrument so the answer I am looking for here is &nbsp; 2<br />
<br />
Thank You
</div>
</div>


Hello I have a table in MS SQL Server that looks like this

Instrument,  KitLot
1                 Z123
1                 Z123
1                 U101
1                 U101

I would want to know how many unique  kitLots there are  per instrument so the answer I am looking for here is   2

Thank You

Need count of values in table

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.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.