Answer Posted / samba shiva reddy . m

creating pivot table:
Columns as Rows

below statement will give as it is data

select
PS.Name, P.Color, PIn.Quantity
from Production.Product P
inner join Production.ProductSubcategory PS
on PS.ProductSubcategoryID = P.ProductSubcategoryID
left join Production.ProductInventory PIn
on P.ProductID = PIn.ProductID
This statement will change the columns as rows

select
*
from
(
select
PS.Name, P.Color, PIn.Quantity
from Production.Product P
inner join Production.ProductSubcategory PS
on PS.ProductSubcategoryID = P.ProductSubcategoryID
left join Production.ProductInventory PIn
on P.ProductID = PIn.ProductID
) DataTable
PIVOT
(
SUM(Quantity)
FOR Color
IN (
[Black],[Blue],[Grey],[Multi],[Red],
[Silver],[Silver/Black],[White],[Yellow]
)
) PivotTable

Can you explain different types of locks in sql server?

941

---

Explain comment on transactions?

972

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

946

---

What is difference between inner join and full join?

1056

---

Does table partitioning improve performance?

956

---

what is a schema in sql server 2005? : Sql server database administration

1017

---

How to create a view with data from multiple tables?

1007

---

How to execute a sql statement using mssql_query()?

1043

---

Why truncate is ddl?

1078

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

980

---

What are some examples of schemas?

968

---

What number aggregate functions are accessible there in sql?

1066

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1037

---

Write a SQL command to insert and update only a particular field?

1102

---

How do I completely remove sql server instance?

1091

---