Thank you Dave, that helps me on where to look. Much appreciated.

Linq to Xml can be easy

That worked. Thanks for the help!

Here's a tip for you. Use the Access Query design to do you table links etc, then look at query as SQL Statement and there's the required code. Steve Jowett ------------------------- It is offen dangerous to try and see someone else's point of view, without proper training. Douglas Adams (Mostly Harmless)

Thanks Paul.

The reason is for faster search indexing. I found this after I posted; Create FUNCTION [dbo].[Dot2LongIP]( @IP VarChar(15) ) RETURNS BigInt AS BEGIN DECLARE @ipA BigInt, @ipB Int, @ipC Int, @ipD Int, @ipI BigInt SELECT @ipA = LEFT(@ip, PATINDEX('%.%', @ip) - 1 ) SELECT @ip = RIGHT(@ip, LEN(@ip) - LEN(@ipA) - 1 ) SELECT @ipB = LEFT(@ip, PATINDEX('%.%', @ip) - 1 ) SELECT @ip = RIGHT(@ip, LEN(@ip) - LEN(@ipB) - 1 ) SELECT @ipC = LEFT(@ip, PATINDEX('%.%', @ip) - 1 ) SELECT @ip = RIGHT(@ip, LEN(@ip) - LEN(@ipC) - 1 ) SELECT @ipD = @ip RETURN ( @ipA * 256*256*256 ) + ( @ipB * 256*256 ) + ( @ipC * 256 ) + @ipD END RETURN @ipI END This does speed it up and seems to meet my needs. Thanks,

The answer was a simple. I missed a double quote in this field; N''

The answer was; WHERE [TimeStamp]>= Convert(varchar(10), DateADD(DAY, -1, GETDATE()), 101) AND [TimeStamp] < Convert(varchar(10), GETDATE(), 101) This gave the info for the previous day only. Brian

Figured this out after I wrote it. The other problem I had was; ORDER BY RT_MCP_Date_Time, Error_Count DESC, RT_MCP_Name, RT_MCP_State, RT_MCP_Alarm_Text I declared the RT_MCP_Date_Time as ErrorDate in the select statement and didn't put it in the ORDER BY statement correctly. Thanks for your help.

If you are planning on using an ActiveRecord design pattern then I suggest you use surrogate keys on your tables, as it tends to make the mapping more straightforward. Mark Churchill Director Dunn & Churchill

Thank You. It is always a good day when you learn something new! Regards, Brian

Got it. I think I can mangle it from here!

Solved my own question; SELECT DISTINCT WaysideName, ST, AlarmMessage, COUNT(AlarmMessage) AS Error_Count FROM AlarmsList GROUP BY WaysideName, ST, AlarmMessage ORDER BY Error_Count DESC, ST, WaysideName, AlarmMessage Thanks Everyone regardless!

The DateTime Column is an odd format from the log file. I think I can figure it out from here. Thanks for you suggestions. Brian

Yes, you assumption is correct. A program that was written by someone else, writes a log entry each time a piece of equipment has a failure or clears the failure. There is no file locks on the file, and I can manually edit it as necessary. The system opens a new file @ midnight each night, so that would be the first time it is opened. I didn't mention it, but I envision this as a Windows Service so that it will be done automatically. Yes, I am looking for some code assistance. I can do the SQL piece, I am just not firmiliar with the FSE for monitoring changes to the contents of a file. Thanks,

Oh, yeah, sorry.

solutionsville wrote: disable the RTB control until the routine is complete Good idea. Wish I'd thought of that! :doh: I suppose the code was chugging along putting in lots of the rtf commands and each time the control had to redisplay itself. Only having to do that one time would account for the big time difference. Good luck with your project! BDF

Your assumptions were correct. Puts things in a different perspective, and I appreciate the answer. ' Brian

You are wellcome! All the best, Martin