<div>
<div class="content wysiwyg-content">
Hello Guys, <br />
<br />
I have an update script:<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-27633775-1"><span>update product set price_sell = 123.45 where code=45</span>
</code></pre>
<br />
the problem is that I need to create a script with price_sell diferent when I am in a determined table, for example:<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-27633775-2"><span>update product set price_sell = case database='viadiesel' then 123.45 else 187.74 end if where code=45</span>
</code></pre>
<br />
how can I do that? Is it possible?<br />
<br />
thanks<br />
Alexandre
</div>
</div>


Hello Guys, 

I have an update script:

(CODE)

the problem is that I need to create a script with price_sell diferent when I am in a determined table, for example:

(CODE)

how can I do that? Is it possible?

thanks
Alexandre

Is there any way to run a update with Case?

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.