<div>
Are these separate columns in your table, or one column with data delimited by a comma?
</div>


Are these separate columns in your table, or one column with data delimited by a comma?

<div>
Assuming we have tableA: prefix, rate &nbsp;and tableB: phone, rate:<br />

<pre><code id="code-20-39298612-1">update b
set rate = A.Rate
from tableB B join tableA A on A.prefix = left(B.Phone, length(A.Prefix))</code></pre>
</div>


Assuming we have tableA: prefix, rate  and tableB: phone, rate:


update b
set rate = A.Rate
from tableB B join tableA A on A.prefix = left(B.Phone, length(A.Prefix))

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have tableA that contains calling prefix and rates, ie<br />
23555,0.025<br />
2354,0.005<br />
123332,0.32<br />
<br />
<br />
and tableB that contain phone number ie<br />
23555222123123<br />
23541334342<br />
12333253444<br />
<br />
I need to update tableB and set tableB.Rate = tableA.Rates. so basically depending on the prefix I have to set the rate on tableB. <br />
<br />
So tableB should look like this: <br />
<br />
23555222123123,0.025<br />
23541334342,0.005<br />
12333253444,0.32<br />
<br />
<br />
How can I do this?<br />
<br />
Thanks.
</div>
</div>


Hi,

I have tableA that contains calling prefix and rates, ie
23555,0.025
2354,0.005
123332,0.32


and tableB that contain phone number ie
23555222123123
23541334342
12333253444

I need to update tableB and set tableB.Rate = tableA.Rates. so basically depending on the prefix I have to set the rate on tableB. 

So tableB should look like this: 

23555222123123,0.025
23541334342,0.005
12333253444,0.32


How can I do this?

Thanks.

Need help with an update statement

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.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.