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

What is use of except clause?

0 Answers  

---

What are the basic features of a trigger in ms sql server?

0 Answers  

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

---

How to rename databases in ms sql server?

0 Answers  

---

Explain how to integrate the ssrs reports in application?

0 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

How to list all login names on the ms sql server?

0 Answers  

---

What is a domain constraint give an example?

0 Answers  

---

How can we remove orphan records from a table?

0 Answers  

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What are the differences between triggers and stored procedures?

0 Answers  

---