troubleshooting Question

Need help with an update statement

Avatar of ezzadin
ezzadin asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008
5 Comments1 Solution262 ViewsLast Modified:
Hi,

I have tableA that contains calling prefix and rates, ie
23555,0.025
2354,0.005
123332,0.32


and tableB that contain phone number ie
23555222123123
23541334342
12333253444

I need to update tableB and set tableB.Rate = tableA.Rates. so basically depending on the prefix I have to set the rate on tableB.

So tableB should look like this:

23555222123123,0.025
23541334342,0.005
12333253444,0.32


How can I do this?

Thanks.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
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 1 Answer and 5 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