opc.three (6/29/2012)

---

Who or what is creating this sense of urgency?

Can anyone give me an idea how best...

Just for example, I went back to my two record sample. Please check out how the staging table is created and then the select from it where I split...

All columns at this time are varchar columns with the exception of the three datetime columns. Those are just that, datetime columns. You may find it easier to...

Not hard to split the date and time parts, but for now we can leave them alone. What I would do now is create a staging table based on...

rjbirkett (6/29/2012)

---

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...

Take a close look at the CTE part of this code. You will see that I have written it to select all records for yesterday from dbo.Syslogd.

with SampleData as...

Good, then the DelimitedSplit8K will work.

rjbirkett (6/29/2012)

---

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]...

rjbirkett (6/29/2012)

---

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...

Take a look at the latest code I...

Bill Talada (6/29/2012)

---

I can save you a ton of trouble. Pass your string to this function and it will return a table of all the tokens in order. ...

rjbirkett (6/29/2012)

---

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...

Another good article to read by the same author is the first one in my signature block. It shows you what to post and how to post it to...

rjbirkett (6/29/2012)

---

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...

I duplicated the sample record you provided earlier, changed the values in the date columns slightly, commented to source string so that it isn't returned. How is this so...