Recent content by NerdTop72

OK so I feel like I am heading in the right direction... I am now stuck trying to separate my data into hours? GMMastros helped me a long time ago with grouping averages per hour. Since I want to use hours as columns. I am stuck on how to get an average of minute data for only 1 hour over...

Thanks for the info! I get stumped trying to be clear to google when I have questions like this! The solution to search for is so simple too. I appreciate the help this forum provides me!

Thanks! I will look into PIVOT, that seems like the right direction. I cannot get the code to run GK53 I am using SQL analyzer for SQL Server 2000 I am trying to fill up a months worth of data with the averages per hour from a tagindex that only = '129' and between 2 dates. really just an...

I am having an issue with displaying information properly for reporting. This is the structure of the raw data in the Table FTB_MHF DateandTime TagIndex Val 9/1/2013 00:31:15 AM 129 6.2 9/1/2013 00:33:15 AM 130 0 9/1/2013 00:33:15 AM 131 1 9/1/2013 01:33:15 AM 132 0...

No, Old Data is never updated.

Thanks Again! Yes I have complete access to the tables. I would like to make the queries faster! I don't think option 1 is a good idea, another application for process control creates these database tables automatically. I have been wanting to format the information to a more usable...

Thanks George! Those worked! I was referencing some old posts you had made from 2008 to my questions looking for the correct way to average hourly data! Thanks again! I have 48,314,220 records in this table total, I tested this query out Select DateAdd(Hour, DateDiff(Hour, 0...

Sorry for the confusion :-) The date ranges are going to be variables and change on many different tables and between different date ranges, I was just using this time period as an example to help explain my question. I thought about my mistake as I saved the data to this post, very sorry...

My appologies, I didnt use the code operators in my first submission. REAL DATA DateAndTime Tag Val 5/4/2010 17:43 24 124.1648865 5/4/2010 17:43 25 199.9999847 5/4/2010 17:43 26 2522500 5/4/2010 17:43 27 0 5/4/2010 17:43 28 1081458 5/4/2010 17:43 29 0 5/4/2010 17:44 0 18.65209198 5/4/2010...

Thanks for the response! I got some weird results SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DateandTime )) AS DateandTime, DATEPART(hh, DateandTime ) AS MyHour, AVG([Val]) AS [Val] FROM ftb_analogs WHERE DateandTime >= '20090701' AND DateandTime < '20091002' AND Tag = 3 --...

I have data logged that I need to average per hour between a date range and I am clueless where to start. I am using Microsoft SQL Server 2000 to access old data... table name = ftb_analogs fields: DateandTime as datetime tag as smallint val as float I am trying to grab data between July 1...

Hi, I currently use Veritas Backup Exec 8.6 with SQL 2000 Agent. I have a SQL database over 30 gigs in size and get an error that says "Connection to the restore target has been lost. Operation Canceled" I have restored other databases from the same tape using the SQL redirect option and...

Hi, I currently have 2 Domain controllers that run windows 2000 server. I am trying to figure out if installing a new windows 2008 server(standard) and adding it to my domain will limit my sharepoint possibilities? I am reading about upgrading the rest of my domain to a 2008 AD and this seems...

Thanks, you both are always great help! -Jason

I was looking for this HttpContext.Resonse.Write("...") I didn't know where to start searching for what I wanted online. I'm glad you guys are here and understand my week skills with English & Grammar. Using the response.write command, how do I leave a variable in the asp page and parse the...