Update one table rows with multiple values of second table

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hi,
Im trying to update a table rows from data which presents in another table...
Data is updating but if another table contains multiple vales, updating table gets only single data. example

SQL

UPDATE RPT SET RPT.T3=GRP.VALUE FROM RPT INNER JOIN GRP ON RPT.T1=GRP.COL1 AND GRP.COL1='STUDENT1'

Here value column in grp table contains 5 values like....

SQL

SELECT VALUE FROM GRP WHERE COL1='STUDENT1'

23
25
13
10
11

But when im using the update command mentioned above, only value(23) is inserting into rpt table into 5 rows of data...

Please help me in this to insert multiple values from one table to multiple rows in another table in single update command...

[edit]SHOUTING removed - OriginalGriff[/edit]

Posted 23-Oct-14 20:53pm

chaitanya556

Updated 23-Oct-14 21:17pm

v3

Add a Solution

Comments

OriginalGriff 24-Oct-14 2:55am

DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalization if you want to be taken seriously.

chaitanya556 24-Oct-14 2:58am

ok sorry... But please help me in this....

OriginalGriff 24-Oct-14 3:06am

Sorry, but no.
You started off the discussion by being rude and shouting at me, and I personally do not answer such questions, or indeed even look at the detail of them.

Others may have different opinions, but that's mine.

Sergey Alexandrovich Kryukov 24-Oct-14 2:58am

"Update with SELECT command"... Can you hear the absurdity in this phrase? Even if the question itself makes sense, you need to think a bit at your titles. Some may not want to open this page if they see such title... :-)
—SA

Maciej Los 24-Oct-14 2:59am

We don't see your screen. Please, provide more details about your issue, like: sample data and expected output.

Maciej Los 24-Oct-14 3:22am

Use this sqlfiddle sample[^]

George Jonsson 24-Oct-14 4:09am

You need to provide the structure of both tables if you want someone to be able to help you.
Otherwise look up examples for the UPDATE command yourself. SQL Update[^]

PhilLenoir 24-Oct-14 9:26am

If there are multiple values in your join for each row in the table to be updated there can only be one value (you are updating a single row). If there is some predicate that would select a single row then that must be present in the WHERE clause so that only a single row is returned.

If there should not be multiple rows then you have an error in your join.

If you need additional rows created, then an UPDATE statement won't do and you should try looking at a MERGE query. As per previous comments, we'd need to know more about your schema (and possibly data) to help.

One final comment: If a select will give you your data do you need to store the data. Storing derived data is almost always unnecessary and can cause problems.

[no name] 24-Oct-14 10:32am

I am not sure what you are trying to do, can you show us what is looks like to start and what you need it to look like in the end?

govardhan4u 30-Oct-14 8:30am

I think. You are trying to say that you want to do some like cross join. So insert multiple values from one to another?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)