<div>
May be you can try Union between select statements like this given below for sample for 2 tables<br />
<br />
Select maintdate,count(maintdate)<wbr /> As NumberofUpdates As Table1, NULL As Table2 from Table1 where maintdate &gt;20071001 group by maintdate<br />
UNION<br />
Select maintdate, NULL As Table1, count(maintdate) As NumberofUpdates As Table2 from Table1 where maintdate &gt;20071001 group by maintdate<br />
&nbsp;<br />
and so on....you can add more statements and note the number of columsn for tables you use.
</div>


<div>
Then I won't get the table heading going across. &nbsp;I'll just have one long column of results.
</div>


<div>
Please let me know if I've not been clear.
</div>


<div>
<div class="content wysiwyg-content">
I have a database with several tables and I want to find out how many rows are added each day.<br />
Each table has a field MaintDate which is the date the row was added. &nbsp;Therefore the query below would give what I want for Table1.<br />
<br />
select maintdate,count(maintdate)<wbr /> As NumberofUpdates from Table1 where maintdate &gt;20071001 group by maintdate<br />
<br />
There are many tables and I want the output in tabular format e.g<br />
<br />
Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table1Updates, Table2Updates<br />
01/01/07 &nbsp; &nbsp; &nbsp; &nbsp;78,65<br />
02/01/07 &nbsp; &nbsp; &nbsp; &nbsp;555,666<br />
03/01/07 &nbsp; &nbsp; &nbsp;100,200
</div>
</div>


I have a database with several tables and I want to find out how many rows are added each day.
Each table has a field MaintDate which is the date the row was added.  Therefore the query below would give what I want for Table1.

select maintdate,count(maintdate) As NumberofUpdates from Table1 where maintdate >20071001 group by maintdate

There are many tables and I want the output in tabular format e.g

Date           Table1Updates, Table2Updates
01/01/07        78,65
02/01/07        555,666
03/01/07      100,200

May be you can try Union between select statements like this given below for sample for 2 tables

Select maintdate,count(maintdate) As NumberofUpdates As Table1, NULL As Table2 from Table1 where maintdate &gt;20071001 group by maintdate
UNION
Select maintdate, NULL As Table1, count(maintdate) As NumberofUpdates As Table2 from Table1 where maintdate &gt;20071001 group by maintdate
 
and so on....you can add more statements and note the number of columsn for tables you use.

Then I won&#39;t get the table heading going across.  I&#39;ll just have one long column of results.

Please let me know if I&#39;ve not been clear.

Row Count of Multiple tables in single table

I have a database with several tables and I want to find out how many rows are added each day.
Each table has a field MaintDate which is the date the row was added.  Therefore the query below would give what I want for Table1.

select maintdate,count(maintdate) As NumberofUpdates from Table1 where maintdate &gt;20071001 group by maintdate

There are many tables and I want the output in tabular format e.g

Date           Table1Updates, Table2Updates
01/01/07        78,65
02/01/07        555,666
03/01/07      100,200

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.