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 do you set a trace flag in sql server?

0 Answers  

---

What is the difference between insensitive and scroll cursor?

0 Answers  

---

What number sorts of privileges are accessible in sql?

0 Answers  

---

How can windows applications connect to sql servers via odbc?

0 Answers  

---

What is filter index?

0 Answers  

---

What is a cube? : sql server analysis services, ssas

0 Answers  

---

What is the difference between inner join and equi join?

0 Answers  

---

What program is used to store the data source file?

0 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

how to rename the table

3 Answers  

---

How m-m relationships are implemented?

2 Answers  

---

Define master database?

0 Answers  

---