Answer / kapil

With the help of pivot table in sql server 2005 we can do so

Answer / vishal

with the help of pivoting....
it will solve the problem of grouping also

Answer / 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

Answer / sai

I agree with this answer..and also we can do the pivot
transaformation in SSIS.

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

---

How to store and query spatial data?

0 Answers  

---

What is CTE in SQL

0 Answers   Infosys,

---

What are different backups available in sql server?

0 Answers  

---

What is the usage of the sign function?

0 Answers  

---

What is the partitioning method?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---

What is the exact numeric data type in sql?

0 Answers  

---

What are the advantages of passing name-value pairs as parameters?

0 Answers  

---

What is WITH CHECK OPTION

3 Answers   Karur Vysya Bank KVB,

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---