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 is molap and its advantage? : sql server analysis services, ssas

992

---

Explain the different types of joins?

997

---

How to create a scrollable cursor with the scroll option?

1004

---

Can I work with several databases simultaneously? : sql server management studio

997

---

What are the different types of triggers in SQL SERVER?

1141

---

Explain few examples of stored procedure over triggers?

1046

---

What is coalesce in sql server?

1059

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1120

---

What are the different types of replication you can set up in sql server?

1052

---

What is filter index?

956

---

What is the difference between deallocate cursor and close cursor?

1265

---

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

1146

---

What are the events recorded in a transaction log?

1002

---

Can you explain various data region available in ssrs with their use?

976

---

What are indexes in ms sql server?

1065

---