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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy