<div>
why it's 9273 and not 9472+2 = 9474, so there is some missing records!!
</div>


why it's 9273 and not 9472+2 = 9474, so there is some missing records!!

<div>
<div class="content wysiwyg-content">
Hello,<br />
I have 2 tables in Sql server 2005.<br />
t1 with 9675 record<br />
t2 with 777 record<br />
<br />
If i execute a query on t1, let's say q1, it returns 9472 records<br />
and if i execute another one, q2 on t2 i have only 2 records returned.<br />
<br />
the 2 queries have the same schema, so i execute them in a union quey, only 9273 records are returned,<br />
<br />
Can someone tell me what's happening here, please ????<br />
thanks
</div>
</div>


Hello,
I have 2 tables in Sql server 2005.
t1 with 9675 record
t2 with 777 record

If i execute a query on t1, let's say q1, it returns 9472 records
and if i execute another one, q2 on t2 i have only 2 records returned.

the 2 queries have the same schema, so i execute them in a union quey, only 9273 records are returned,

Can someone tell me what's happening here, please ????
thanks

T-SQL Union queries

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.