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.

What are the differences between user defined functions and stored procedures?

0 Answers  

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

Explain partitioned view?

0 Answers  

---

What is @@rowcount in sql?

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

What is a self join in sql server?

0 Answers  

---

State a few properties of relational databases?

0 Answers  

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

What is a rollup clause?

0 Answers  

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  

---

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

---