We help IT Professionals succeed at work.
Get Started

Edit Top 200 Rows On a Temporary Table

1,185 Views
Last Modified: 2012-05-12
All,

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!  :)
Comment
Watch Question
CyberSecurity Analyst
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE