Answer Posted / gopi muluka

Using PIVOT operator we can achieve this in SQL 2005

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'
GO
SELECT CITYID, [1] AS NAME1,[2] AS NAME2,[3] AS NAME3, [4]
AS NAME4
FROM
(
SELECT CITYID,ContinuationID, CITYNAME
FROM CITY
) P
PIVOT
(
MAX(CITYNAME)
FOR ContinuationID IN
([1],[2],[3],[4])
) AS PVT
ORDER BY CITYID
GO
DROP TABLE CITY

Explain unique key in sql server?

536

---

what are database files and filegroups? : Sql server database administration

497

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

557

---

When a primary key constraint is included in a table, what other constraints does this imply?

597

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

653

---

---

What is query cost in sql server?

549

---

Explain sub-query?

569

---

What is user-defined functions? What are the types of user-defined functions that can be created?

564

---

Tell me in brief how sql server enhances scalability of the database system?

522

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

606

---

How to recompile stored procedure at run time?

565

---

Can you force a query to use a specific index?

528

---

How to execute stored procedure in select statement sql server?

529

---

What are the tables in sql?

621

---

What are the elements of dbms?

541

---