Answer / sush4

CREATE TABLE YourTable
(
ID INT,
PlateNo INT,
[Type] VARCHAR(20),
[Image Name] VARCHAR(20)
);

INSERT INTO YourTable
VALUES
(27,455,'User','img1.jpg'),
(32,542,'Alternative','img2.jpg');
SELECT * FROM YourTable

;WITH Cte AS
(SELECT T.*,T2.PlateNo PlateNo2, T2.Type Type2, T2.[Image Name] [Image Name 2] FROM YourTable T JOIN YourTable T2 ON T.ID<>T2.ID)
UPDATE Cte SET PlateNo = PlateNo2, Type=Type2,[Image Name]=[Image Name 2]


SELECT * FROM YourTable

DROP TABLE YourTable

How to truncate a table first before running a package?

1 Answers  

---

What is Left Outer Join?

2 Answers  

---

What is MSDE?

2 Answers  

---

What is RMS migrations?

0 Answers   Satyam,

---

What is sql server query analyzer?

0 Answers  

---

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

---

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

---

What happens if null values are involved in boolean operations?

0 Answers  

---

What is difference between Triggers and store procedure?

2 Answers  

---

What is the order by used for?

0 Answers  

---

Do you know query execution plan?

0 Answers  

---

What is the difference between OLEDB and ODBC

4 Answers   CFCI,

---