I will post it, but which tags to use? They are all code, this is delimited text strings.

In the interest of getting things done....

"|CALL_END |22 ...

Ha! No fear. OK, maybe a little bit. I modified the select, sorted out my tables, did some messing around and found only one problem. It all...

Lynn and Craig,

Sitting in traffic gives you pause for thought and time to think. I omitted the fact that SYSLOG gets all the syslog data from the gateway (mostly...

You beat me to it. I was modifying your script to create the date/time pieces of the puzzle. I have added the details of the other table since...

All, just so you know this is not a waste of your time, I work for an energy company. CDR is important because in the event of a gas...

Craig,

I don't know what to say. Brilliant explanation. If you could see my code you would know why I understand RBAR:-) There are really only two tables...

Yes, it does work. I think I get the picture. Use the script to put the data into dbo.CDR directly, dump all my useless code, and have access...

Yes, it does work. I think I get the picture. Use the script to put the data into dbo.CDR directly, dump all my useless code, and have access...

Lynn, you have me at a disadvantage. RBAR I understand, a set of data I sort of understand, but I'm old school SQL. I'm assuming that by "set...

Lynn,

It came back with 1024 as the max length.

Rob

Lynn,

Coffee not working. Forgot to paste the SQL in:-/

USE [SYSLOG]

GO

/****** Object: Table [dbo].[Syslogd] Script Date: 06/29/2012 14:23:29 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Syslogd](

[MsgDate] [date]...

I assume you are looking for this. The table is being updated by the syslog service so the names ar based on what syslog required. Not pretty but...

Lynn,

How am I going to process each record without looping through? For/Next? Next n? you have to iterate somehow, right?

Rob

Bill, I'm sorry, I was not ignoring you, I was trying to figure out if I could use that function. There are 45 separate fields once the string is...

Lynn, you have don more than enough. I need to keep reading, but I get the general principle, and I think you can see why CDR processing can be...