Answer Posted / 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 verify a user name with sqlcmd tool?

587

---

How many types of database relationship in sql server?

566

---

Explain time data type in sal server 2008?

552

---

What is the difference between row_number and dense_rank?

444

---

what are the types of indexes? : Sql server database administration

602

---

---

What are sp_configure commands and set commands?

566

---

What do you mean by sql server 2005 express management tools?

795

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

555

---

How to define and use table alias names in ms sql server?

565

---

How to transfer a table from one schema to another?

560

---

How do you create type- insensitive operator?

572

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1858

---

Define cross join in sql server joins?

593

---

What is a trigger what are the advantages of trigger?

531

---

How is sql server used?

550

---