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 Update from select query in sql server?

0 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

List the various tools available for performance tuning?

0 Answers  

---

Is null in sql server?

0 Answers  

---

What is RAID and what are different types of RAID configurations?

8 Answers   Wipro,

---

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

What is Index Segmentation ?

1 Answers   TCS,

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---