Bill Talada (6/29/2012)

---

This is extremely simple and allows you to do whatever transforms you need. Don't worry about performance. It will be within milliseconds of anything else. ...

rjbirkett (6/29/2012)

---

Lynn, I am sufficiently humbled. That looks exactly as it does in my VBA string (apart from the returned data has the whole string in the first column.

So,...

Scalar UDF's introduce RBAR code. This function has to be called for each record. Post the code for the query and the function. It may be possibile...

I think this is as far as I go for now. You need to review everything provided and work through it so you understand what is going on with...

Violating my own statements here, added conversion steps on the datetime columns directly to the code. Run this and check the output.

with SampleData as (

select * from (VALUES (

'|CALL_END...

If others write all your code, how do you plan on supporting it if something goes wrong? Lowell is right, you need to start doing this and then asking...

Step one.

Run the following code, after ensuring you have the delimited split routine I call created. Look at the data returned, does this look correct so far?

with SampleData as...

rjbirkett (6/29/2012)

---

Lynn, thanks for all the help. I'm getting the idea. As for splitting the field that contains "UTC" SQL does not know what to do with...

dsh_roy (6/29/2012)

---

Hi Friends,

I am running the following piece of code in on DatabaseA and also on DatabaseB.

DECLARE @MaxLoadKey int,

...

Also, is there a reason to separate the date and time into seperate columns? You may want to keep the date and time together as a datetime data type.

rjbirkett (6/29/2012)

---

Lynn,

Clumn names are here for the working dbo_CDR table I'm using now.

[call_status]

,[channel_num]

,[sipcall_ident]

...

rjbirkett (6/29/2012)

---

Lynn, I did not import the data, it is written to a table via a database connection from the syslog server, which is a table with 5 columns (since...

Hopefully this helps a little bit.

This is the delimited split routine used in the code that follows:

USE [SandBox]

GO

/****** Object: UserDefinedFunction [dbo].[DelimitedSplit8K] Script Date: 06/29/2012 11:53:50 ******/

IF...

I could also use the column names you want these put into. Initially, I would look at just doing it to a table where all the columns are defined...

So you imported the data as a single column of text instead of spliting it by the column deliminator (|). Each row has the same number of columns, correct?...