What Query for some issue ?

[Andrzej]

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:

[hspc]

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

[Andrzej]

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

I use MS SQL Server 2000

[hspc]

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/thomasswilliams/archive/2005/10/23/133383.aspx

[Andrzej]

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

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.