Answer Posted / prakash

CREATE TABLE CITY (CITYID INT, ContinuationID INT, CITYNAME
VARCHAR(50))
GO
INSERT CITY
SELECT 1 ,1, 'SAN'
UNION ALL
SELECT 1, 2, 'DIEGO'
UNION ALL
SELECT 2, 1, 'SAN'
UNION ALL
SELECT 2, 2, 'FRANCISCO'
UNION ALL
SELECT 3, 1, 'CHICAGO'
UNION ALL
SELECT 4, 1, 'NEW'
UNION ALL
SELECT 4, 2, 'YORK'
UNION ALL
SELECT 4, 3, 'CITY'


SELECT cityid,
max(CASE P.ContinuationID WHEN 1 THEN
P.CITYNAME ELSE '' END) AS Name1,
max(CASE P.ContinuationID WHEN 2 THEN
P.CITYNAME ELSE '' END) AS Name2,
max(CASE P.ContinuationID WHEN 3 THEN
P.CITYNAME ELSE '' END) AS Name3
FROM CITY AS P
GROUP BY P.cityid

What are “lock” hints?

998

---

What are the different types of indexes?

1045

---

What is bit data type? What's the information that can be stored inside a bit column?

873

---

What is cached report?

135

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

182

---

What is the difference between varchar and nvarchar?

897

---

How to make conditional sum in ssrs?

173

---

What is a mixed extent?

948

---

What are the advantages of partitioning?

1043

---

How to configure and test odbc dsn settings?

1096

---

Can you please differentiate between a primary key and a unique key?

949

---

Does a full backup include transaction log?

906

---

What is a performance monitor?

917

---

What is difference between drop truncate and delete?

1014

---

What are the requirements on sql server network connections?

896

---