<div>
Thank you for your time and consideration on my behalf. &nbsp;
</div>


Thank you for your time and consideration on my behalf.  

<div>
<div class="content wysiwyg-content">
I am writing a stored procedure to update a products placements. I have a legacy database that contains a product table, a placements table, and a ProductsInPlacements table. &nbsp;The productsInPlacements table contains a productID as a FK, and a placementsID as a FK. &nbsp;<br />
What is the best practice for updating this type of relationship? &nbsp;Currently I am updating, I first delete all the records from ProductsInPlacements that match a given product ID, then I loop calling an update procedure that take the productId and placementID and updates the ProductsInPlacements table. &nbsp;<br />
<br />
This requires two stored procedures, one to delete all the records and another to update the table. &nbsp;Is this the best way? &nbsp;<br />
<br />
I wrap everything in a transaction in case something bad happens during the update. I am using SQL server. &nbsp;<br />
<br />
Any guidance would be greatly appreciated. &nbsp; &nbsp;
</div>
</div>


I am writing a stored procedure to update a products placements. I have a legacy database that contains a product table, a placements table, and a ProductsInPlacements table.  The productsInPlacements table contains a productID as a FK, and a placementsID as a FK.  
What is the best practice for updating this type of relationship?  Currently I am updating, I first delete all the records from ProductsInPlacements that match a given product ID, then I loop calling an update procedure that take the productId and placementID and updates the ProductsInPlacements table.  

This requires two stored procedures, one to delete all the records and another to update the table.  Is this the best way?  

I wrap everything in a transaction in case something bad happens during the update. I am using SQL server.  

Any guidance would be greatly appreciated.    

Stored Procedure to Update a Many - to - Many Relationship

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

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.