Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
update from value in different row of same table and column
thank you so much for explaining... I believe this is exactly what I was trying to do... I will run it and see... Thx again...- sqlsinger
- Post #3
- Forum: Microsoft SQL Server: Programming
-
update from value in different row of same table and column
I haven't used subqueries or self-joins a lot... not sure if that's what I need though... Here is what is needed - all in one table: to update the cost of an inventory item in location 1 with the cost of the same item from location 2 (if it exists in location 2)... Items and locations are in...- sqlsinger
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
