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.

How to create a login account in ms sql server to access the database engine using "create login" statements?

0 Answers  

---

What is the purpose of UPDATE STATISTICS?

2 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

---

What do you know about normalization and de- normalization?

0 Answers  

---

What stored by the msdb?

0 Answers  

---

Can you explain the role of each service?

1 Answers  

---

Explain indexed views and partitioned view with their syntax.

0 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

---

What are the difference between “where” and “having” clause in sql server?

0 Answers  

---

How to Debug a Stored Procedure?

5 Answers   Allianz,

---

why would you call update statistics? : Sql server database administration

0 Answers  

---