What Query for some issue ?

Hello

I have been writting a DataBase Application ... and I need to creat an query.
I'm not familar with SQL too much.

I think that the best solution to describe my problem will be picture as follows:

This is a pivoting functionality. Achieving it depends on the database you use. Can you mention it?

Quote:

---

Originally Posted by hspc

This is a pivoting functionality. Achieving it depends on the database you use. Can you mention it?

---

I use MS SQL Server 2000

Unfortunately, MS SQL Server 2000 did not support pivoting.
However you can try tips mentioned in these links to overcome this issue:
http://www.mssqltips.com/tip.asp?tip=937
http://www.dotnetjunkies.com/WebLog/...23/133383.aspx

Thanks a lot.
There are very usefull links. Unfortunately I'm not able to rate your perfect post.

by the way
please find answer below for my issue

Code:

---

USE ABBMeasureHistory

SELECT T1.X,
SUM(CASE T2.Sensor WHEN 4 THEN T2.Val ELSE 0 END) AS Sensor4,
SUM(CASE T2.Sensor WHEN 5 THEN T2.Val ELSE 0 END) AS Sensor5,
SUM(CASE T2.Sensor WHEN 6 THEN T2.Val ELSE 0 END) AS Sensor6,
SUM(CASE T2.Sensor WHEN 7 THEN T2.Val ELSE 0 END) AS Sensor7
FROM Table_1 T1, Table_2 T2
WHERE T1.id_t1 = T2.id_t1 AND T1.id_t1=1001
GROUP BY T1.X
GO

---

The more I learn SQL the more I am impressed by SQL.