<div>
Provided solution<br />
question abandoned.
</div>


<div>
<div class="content wysiwyg-content">
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204084/Table.png" target="_blank" title="Table.png (10 KB)"><img alt="Table.png" class="file-block lazyload" style="max-width: 322px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204084/Table.png" /></a>I have add one column like 'AdditionQty' and value of that column like which orderid is '0' for particular Adviceid as well as Itemid. Second one is if Orderid &nbsp;0 is found but that itemid &nbsp;is not match &nbsp;in that Adviceid then min adviceid add that Qty as AdditionQty.I want output like below table...<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204085/Output-Table.png" target="_blank" title="OutPut Table (12 KB)"><img alt="OutPut Table" class="file-block lazyload" style="max-width: 385px;" data-src="https://filedb.experts-exchange.com/incoming/2017/11_w44/1204085/Output-Table.png" /></a>
</div>
</div>


Table.png

Output-Table.png


I have add one column like 'AdditionQty' and value of that column like which orderid is '0' for particular Adviceid as well as Itemid. Second one is if Orderid  0 is found but that itemid  is not match  in that Adviceid then min adviceid add that Qty as AdditionQty.I want output like below table...



I have following table.I want Query in SQL as per output Table

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

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.