September 5, 2008 08:42pm pdt

Member Login

Hall of Fame

Yearly

1chapmandew 2,079,790
2angelIII 1,422,162
3aneeshatti... 513,981
4mark_wills 473,916
5ee_rlee 315,195
6brejk 226,005
7dtodd 209,505
8momi_sa... 185,979
9acperkins 182,413
10rickchild 170,740
11BrandonG... 164,870
12ptjcb 160,219
13Thomasian 155,142
14EugeneZ 151,550
15sbagireddi 138,982
16dportas 129,715
17ScottPletc... 123,915
18jgv 117,421
19bashka_... 116,400
20appari 114,604
21PFrog 113,160
22chrismc 112,389
23PedroCGD 112,120
24DanielWilson 110,274
25tedbilly 107,990

	[x] Attachment Details

Update Statement on inner join

Zones: SQL Server 2005, MS SQL Server

Tags: T-SQL, T-SQL

Update statement in T-SQL

I have a table TransactionTable which has six columns,
ID - this is the primary key,
Region
RegionValue
Code
Date
Area

I have another table Translation
which has four columns, ID, InboundValue, Type, OutboundValue

What I need to do is set the RegionValue of the TransactionTable to the value of the OutboundValue from Translation table , where the date and area equals the values 05/01/2008 and 'NA' and the Code equals the InboundValue from the Translation table and the Type of the Translation is 'X'

Not sure if this is going t work...

Update TransactionTable
Set RegionValue = OutboundValue
where Date ='05/01/2008'
and Area = 'NA'
inner join Translation
on Code = InboundValue
and Type = 'X'

         
             Update TransactionTable 
Set RegionValue = OutboundValue
where Date ='05/01/2008'
and Area = 'NA'
inner join Translation
on Code = InboundValue
and Type = 'X'

Start your free trial to view this solution

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.9

Question Stats

Zone: Microsoft

Question Asked By: countrymeister

Solution Provided By: chapmandew

Participating Experts: 2

Solution Grade: A

Translate:

Loading Advertisement...

20080723-EE-VQP-34 / EE_QW_2_20070628