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.

Explain cross join or cartesian product in sql?

0 Answers  

---

What is the use of RDBMS?

0 Answers   Wipro,

---

What is nested transaction?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

---

How to test values returned by a subquery with the in operator?

0 Answers  

---

How to drop an existing table?

0 Answers  

---

How are the exceptions handled in sql server programming?

0 Answers  

---

Explain datetimeoffset data type in sal server 2008?

0 Answers  

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

What is the difference between TRUNCATE and DROP?

0 Answers  

---