<div>
Tigin and if i would like to change only this rows where the dest is empty in table custo
</div>


Tigin and if i would like to change only this rows where the dest is empty in table custo

<div>
<div class="content wysiwyg-content">
Hi,<br />
I`ve got 2 tables: first - prod, second - custo<br />
table prod<br />
idProd(int) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dest( varchar )<br />
8921 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t1<br />
3211 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t1<br />
3232 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t2<br />
<br />
table custo<br />
idProdWe (int) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dest ( varchar)<br />
8920 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t2<br />
8111<br />
8921<br />
3232<br />
4811 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t1<br />
I need to update records in table custo if there are the same values in columns idProd and IdProdWe. As Update i mean to insert values from dest column to custo table
</div>
</div>


Hi,
I`ve got 2 tables: first - prod, second - custo
table prod
idProd(int)          dest( varchar )
8921                     t1
3211                     t1
3232                     t2

table custo
idProdWe (int)          dest ( varchar)
8920                           t2
8111
8921
3232
4811                           t1
I need to update records in table custo if there are the same values in columns idProd and IdProdWe. As Update i mean to insert values from dest column to custo table

Update with 2 tables

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.

Microsoft SQL Server 2008

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.