March 29, 2013 at 4:08 am
Hi All
I had a huge situations and at the moment only revolve by VB and XML, but is not a fast and easy way to force my users to do.
Real world I receive data from several and diverse equipment and each of one insert on central table the following information.
Date/Time Insert Tag Device Value
------------------- ---------- ----------- ----------
03-28-2013 09:05 1305 125 1251,69
03-28-2013 09:05 1305 126 1261,69
03-28-2013 09:05 1305 127 1271,69
03-28-2013 09:05 1305 128 1281,69
03-28-2013 09:05 1305 129 1291,69
03-28-2013 09:05 1305 130 1301,69
03-28-2013 09:15 1305 125 1252,69
03-28-2013 09:15 1305 126 1262,69
03-28-2013 09:15 1305 127 1272,69
03-28-2013 09:15 1305 128 1282,69
03-28-2013 09:15 1305 129 1292,69
03-28-2013 09:15 1305 130 1302,69
I try several Joing {Inner / All / Out} but not with no sucess., using also a temporary table , but with VB
I need a single output from data above decribe like this:
Data/Time D125 D126 D127 D128 D129 D130
------------------ ---------- ---------- ---------- ---------- ---------- ------------
03-28-2013 09:00 1251,69 1261,69 1271,69 1281,69 1291,69 1301,69
03-28-2013 09:15 1252,69 1262,69 1272,69 1282,69 1292,69 1302,69
I now is not so easy ask, but I thought I can bring this query directly from SQL Server.
Any one can give some ideia to do this.
Thanks
Paulo Afonso
😎
March 29, 2013 at 4:44 am
If I'm not mistaken you want a row for every date/time combination and put the values in different columns?
This would be done with a PIVOT statement.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 29, 2013 at 5:46 am
March 29, 2013 at 5:48 am
Koen Verbeeck (3/29/2013)
If I'm not mistaken you want a row for every date/time combination and put the values in different columns?This would be done with a PIVOT statement.
😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply