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:
Printable View
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?
I use MS SQL Server 2000Quote:
Originally Posted by 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/...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
The more I learn SQL the more I am impressed by SQL.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