Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smakdown61
Starting Member
2 Posts |
 Posted - 2014-04-22 : 08:04:55
|
| I'm a bit of a SQL newb but have been tasked with coming up with some code to retrieve values from a historian database. I'm retrieving the name of an object (tag) and its value at a specific time every month of the year. However, the year will be user defined parameter coming from a report. So if the user selects 2014 it should query on 1/1/2014,2/1/2014 and so on.I came up with the simple part of the query which is looking up the tag names and associated values:SELECT Tagname,value From runtime.dbo.History WHERE Tagname IN ('Tag1', 'Tag2') and wwVersion = 'Latest' and DateTime = @DateHere are the issues I need to solve:1. I can manually set the @Date but I'd like to have it do whats described above. I'm thinking some type of loop might be used?2. I'm not sure how to output it into table format to look like:Tag 1, (jan value), (feb value), (mar value), etc...Tag 2, (jan value), (feb value), (mar value), etc...Any help would be appreciated. Thanks! |
|
|
|
|
|
Query DB by date w/ results to table