I've been tasked with updating a little over 200 rows in our DB. Problem is, I only have INSERT, DELETE, AND UPDATE permissions. I've created a temporary table #Cell_Phones, but I just realized you can't use the Edit Top 200 Rows with a temporary table. Is there another way to accomplish this? I've already made all 200 edits in Excel and just want to paste the new results into this table. I have a cursor already set to update the descriptions as long as the id=@id.
Hope someone can help me so I don't have to do this manually - AGAIN! :)