<div>
&gt;I execute two select with intersect.<br />
Posting the T-SQL of these queries would greatly help us solve the problem.
</div>


>I execute two select with intersect.
Posting the T-SQL of these queries would greatly help us solve the problem.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I execute two select with intersect. The tables contains static data and I have executed the query several times, the result is not the same, the number of rows is different.<br />
<br />
Why <br />
<br />
<br />
Thanks<br />
<br />
Regards
</div>
</div>


Hello,

I execute two select with intersect. The tables contains static data and I have executed the query several times, the result is not the same, the number of rows is different.

Why 


Thanks

Regards

problem with query select with intersect

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.