Actually.. I'm usinig SQL2005 .. should have mentioned that...

When I ran your code got

Msg 207, Level 16, State 1, Line 1

Invalid column name 'URL'.

Msg 207, Level 16, State 1,...

Yes.... I had tried that, but I was searching on a field containing data/time data, but the datatype it was set to was Varchar (30) .. which caused the search...

If I want to add a time parameter restriction criteria to this, being that the timedate fields are all Varchar types, how would I do that? For...

Wow... so simple when you know how!

Thanks! .. and.. happy new year!

Thanks for the...

Thanks....

Thanks!!!

Is there a means to analyze the output from say a syslog output and determine the optimum data type and size the target SQL table fields should be?

After reading your posts, realized I had not even set up Indexing on this database. I ran the SQL database tuner and turned indexing on for a couple of...

Great idea... thanks!

Yes... it does have one...

Thanks for the help

I've been investigating this syslog parsing problem further, and noted using my HEXEditor that the field I need to have parsed (the MSGText field) is actually internally delimited with HEX...

It looks like this code combines the results of the first few columns and then parses them along with the last column (the MsgText http column) back out. I'm...

The text file containing 50 records is attached.

Jeff Moden (11/2/2010)

---

The conversion to Excel messes up a bunch of things. Can you just direct the ouput of the query in...

The data is an event log output from a Web Filter device. I collect the log using a KIWI Syslog server which populates the collected log directly into a...