<div>
<div class="content wysiwyg-content">
Why does the following TSQL resulits in all records being updated not Top 70. &nbsp;Thanks<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Update Tbl_Stock_Take_Item <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set Page_Num = @Page_Count<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;where exists<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(Select Top 70 Tbl_Stock_Take_Item_Id<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;From Tbl_Stock_Take_Item as Tabtwo<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Where Tbl_Stock_Take_Item.Tbl_St<wbr />ock_Take_I<wbr />tem_Id = Tabtwo.Tbl_Stock_Take_Item<wbr />_Id<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Order By Tabtwo.Location asc)<br />
<br />

</div>
</div>


Why does the following TSQL resulits in all records being updated not Top 70.  Thanks

	Update Tbl_Stock_Take_Item 
	Set Page_Num = @Page_Count
	where exists
	(Select Top 70 Tbl_Stock_Take_Item_Id
	From Tbl_Stock_Take_Item as Tabtwo
	Where Tbl_Stock_Take_Item.Tbl_Stock_Take_Item_Id = Tabtwo.Tbl_Stock_Take_Item_Id
	Order By Tabtwo.Location asc)



TSQL Update on same table selecting TopX recs from subquery but ALL records updating.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.