Updation in sqlserver table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,
I have a table with five rows. i want to update the last four rows with the values of first record. First row contain the master record. How can i do that. plz help me

Thanks in advance
kunjammu

Posted 8-Jan-13 21:57pm

Kunjammu

Updated 8-Jan-13 22:01pm

v2

Add a Solution

Comments

[no name] 9-Jan-13 3:59am

please elobrate your question

Kunjammu 9-Jan-13 4:01am

made some changes in my question

[no name] 9-Jan-13 4:08am

IN UR TABLE ANY PK COL IS THERE

Kunjammu 9-Jan-13 4:09am

yes. RECNO is my Pk

MT_ 9-Jan-13 4:08am

Do you have primary key set on the table ?

Kunjammu 9-Jan-13 4:10am

yes. RECNO is my Pk

MT_ 9-Jan-13 4:15am

Good, check the solution below. That should help.

3 solutions

Solution 2

SQL

UPDATE TABLE_NAME SET
COL_NAME=(SELECT COL_NAME FROM TABLE_NAME WHERE RECNO= 1)

Posted 8-Jan-13 22:10pm

pranathis012

Updated 8-Jan-13 22:13pm

v3

Solution 1

Sorry, I misread the question. You can do this:

update table1 set val = ( select top 1 val from table1 order by id)

You'd have to do that for each column. You can do it all in one, if you like.

update table1 set val = ( select top 1 val from table1 order by id),
val2 = (select top 1 val2 from table1 order by id), etc

Posted 8-Jan-13 22:04pm

Christian Graus

Updated 8-Jan-13 22:13pm

v2

Comments

Kunjammu 9-Jan-13 4:09am

can u plz give me an example

Christian Graus 9-Jan-13 4:12am

Oh, I see. Update table set val = (select top 1 val from table) will do it. I misread your question. Make sure top 1 is selecting the first record, perhaps order by the id to do that ?

Add a Solution

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)

MT_ · Accepted Answer · 2013-01-08T22:12:00

Solution 3

Check following query

SQL

UPDATE myTable
SET
column1 = firstrow.column1,
column1 = firstrow.column1,
column1 = firstrow.column1
FROM
    (
    SELECT
    	column1,column2,column3
    FROM MyTable
    WHERE
    	RECNO=1
    ) firstrow
where RECNO<> 1

That should serve the purpose

Hope that helps
Milind

Posted 8-Jan-13 22:12pm

MT_

Updated 8-Jan-13 22:15pm

v2

Comments

Kunjammu 9-Jan-13 4:44am

thank u...