<div>
Thanks! &nbsp;Wow, that was a lot easier than I made it out to be.
</div>


Thanks!  Wow, that was a lot easier than I made it out to be.

<div>
<div class="content wysiwyg-content">
I need some assistance with the sql to accomplish the desired outcome. &nbsp;<br />
Here is an example of what the data could look like in the table.<br />
Table X<br />
&nbsp; &nbsp;L_ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C_ID &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Indem<br />
&nbsp;32566 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54345 &nbsp; &nbsp; &nbsp; &nbsp;25.00<br />
&nbsp;32566 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54346 &nbsp; &nbsp; &nbsp; 26.00<br />
&nbsp;32566 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54346 &nbsp; &nbsp; &nbsp; &nbsp;37.00<br />
&nbsp;32566 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;54347 &nbsp; &nbsp; &nbsp; &nbsp; 45.00<br />
<br />
I will be writing this data to another table. &nbsp;What I will be doing is taking everthing from the specified table X with the same L_ID and inserting it into another table. &nbsp;The one thing that will change is that I need to add the Indem column when the C_ID is equal to another C_ID. &nbsp;So with that said the C_ID with 54346 &nbsp;will need to have their Indem values added together and inserted into table Y. &nbsp;
</div>
</div>


I need some assistance with the sql to accomplish the desired outcome.  
Here is an example of what the data could look like in the table.
Table X
   L_ID                        C_ID          Indem
 32566                      54345        25.00
 32566                      54346       26.00
 32566                      54346        37.00
 32566                      54347         45.00

I will be writing this data to another table.  What I will be doing is taking everthing from the specified table X with the same L_ID and inserting it into another table.  The one thing that will change is that I need to add the Indem column when the C_ID is equal to another C_ID.  So with that said the C_ID with 54346  will need to have their Indem values added together and inserted into table Y.  

Looping through a table and adding a column

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.