Viewing 4 posts - 1 through 4 (of 4 total)
Never thought of that. This question cleared my doubts.Good One!
July 3, 2017 at 6:04 am
#1949117
Put the subquery into temporary table and then join the temporary table with update statement. Do the same for both update statements. SELECT TOP (@MaxRows) OrderId INTO #TempOrders
June 28, 2017 at 12:52 am
#1948500
good question
September 20, 2016 at 11:37 pm
#1902072
I think below URL will suffice your curiosity
https://technet.microsoft.com/en-us/library/cc298801.aspx
:-):-):-)
Rohit Kumar
July 25, 2016 at 12:40 am
#1891773