<div>
I believe, it would much nicer if you query it as follows:<br />
<br />

<pre><code id="code-20-42541896-1">select plant, count(1)
from TbDocs td
group by plant
order by plant</code></pre>
</div>


I believe, it would much nicer if you query it as follows:



select plant, count(1)
from TbDocs td
group by plant
order by plant

<div>
<div class="content wysiwyg-content">
I need to run several &nbsp; select queries(Sql Server 2014 ) and write the results to an excel sheet<br />
<br />
Example <br />
select count(docname) &nbsp;from TbDocs where plant = 'Plant1' &nbsp; ------ &nbsp; Write &quot;Plant1&quot; in first column , count in second column of first row<br />
select count(docname) from TbDocs where plant = 'Plant2' &nbsp; ----- &nbsp; Write &quot;Plant2&quot; in first column , count in second column of second row<br />
select count(docname) from TbDocs where plant = 'Plant3' &nbsp; ----- &nbsp; Write &quot;Plant3&quot; in first column , count in second column of third row<br />
.. has 20 &nbsp;plants total<br />
(It is desirable, If I can have a header row as first row . But not a must)<br />
Can I have a batch sql script running and writing it to a PlantCount excel file in one shot?
</div>
</div>


I need to run several   select queries(Sql Server 2014 ) and write the results to an excel sheet

Example 
select count(docname)  from TbDocs where plant = 'Plant1'   ------   Write "Plant1" in first column , count in second column of first row
select count(docname) from TbDocs where plant = 'Plant2'   -----   Write "Plant2" in first column , count in second column of second row
select count(docname) from TbDocs where plant = 'Plant3'   -----   Write "Plant3" in first column , count in second column of third row
.. has 20  plants total
(It is desirable, If I can have a header row as first row . But not a must)
Can I have a batch sql script running and writing it to a PlantCount excel file in one shot?

Write multiple sql server count query result to a single excel  file

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

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.