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 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 ?

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

Add a Solution

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...

Updation in sqlserver table

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Updation in sqlserver table

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us