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

When would you use the stored procedures or functions?

947

---

What are the advantages of policy management?

942

---

Name some of the open source software that you can use in alternative to SSR?

151

---

What is the difference between a primary key and a unique key? Are they the same?

1009

---

How column data types are determined in a view?

898

---

Mention the uses of stored procedures.

927

---

What are the new data types are introduced in sql 2000?

859

---

What is implicit cursors?

1002

---

What is the bookmark lookup and rid lookup?

943

---

Explain cross join or cartesian product in sql?

840

---

What are “phantom rows”?

1608

---

Explain the purpose of indexes?

900

---

Can sql server 2016 run on windows 7?

861

---

Which joins are sql server default?

937

---

What sql server means?

909

---