troubleshooting Question

How to accomplish this task?

Avatar of sepknow
sepknow asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
3 Comments2 Solutions190 ViewsLast Modified:
I have a csv file which contains two columns of data of about 300 records.
The first column of the csv is the key.
I would like to update the value of second column of csv into table Table_A in SQL Server 2005
using the query below:

update A
set A.Value2= CSV.Column2
from Table_A
inner join
(
...
...
) CSV
on A.Key=CSV.Column1

How can this be done?

ASKER CERTIFIED SOLUTION
momi_sabag

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros