<div>
If you need the whole record from tableB, you can use outer apply<br />

<pre><code id="code-20-35125432-1">SELECT t1.*, t2.*
FROM tableA t1 OUTER APPLY
    (SELECT TOP 1 *
       FROM tableB
       WHERE t1.fieldname&gt;=fieldname
       ORDER BY fieldname DESC
     ) t2</code></pre>
</div>


If you need the whole record from tableB, you can use outer apply


SELECT t1.*, t2.*
FROM tableA t1 OUTER APPLY
    (SELECT TOP 1 *
       FROM tableB
       WHERE t1.fieldname>=fieldname
       ORDER BY fieldname DESC
     ) t2

<div>
<div class="content wysiwyg-content">
I have a table a with numeric values<br />
<br />
1<br />
3<br />
5<br />
6<br />
12<br />
34<br />
54<br />
16<br />
<br />
And another<br />
0<br />
10<br />
20<br />
30<br />
40<br />
I need a query to give me in wich ranga the values of table 1 fall.<br />
<br />
for example, 6 relates to record 1 (0&lt;=6&lt;10) 31 relates to record 4 (30&lt;=31&lt;40)<br />

</div>
</div>


I have a table a with numeric values

1
3
5
6
12
34
54
16

And another
0
10
20
30
40
I need a query to give me in wich ranga the values of table 1 fall.

for example, 6 relates to record 1 (0<=6<10) 31 relates to record 4 (30<=31<40)


Range of a field depending in a related table ms sql 2995

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.