rjbirkett (6/29/2012)

---

The data is IN a table already. I got creative. The Mediant 2000 IP telephony gateway uses syslog to export the data. I used the KIWI...

Has this operator, 'MSXOperator' , been created?

You could use BULK INSERT to load the data into a staging table where all the columns are declared the appropriate size of character data, then use T-SQL to cleanup...

Scorpion_66 (6/29/2012)

---

You can delete as many rows from the table as you like. The trigger fires FOR EACH ROW, so is fine handling one record. Test it, you'll see. Just...

Assuming each column in the text is seperated by a pipe (|) character, and that the data is located in a text file, you may want to look at the...

(Bob Brown) (6/29/2012)

---

I go this wrong because I answered 1. But that was because if you execute the select statement again by itself, you will get one...

Charmer (6/29/2012)

---

Lynn Pettis (6/29/2012)

---

Now, did you take the code that I posted based on David's post to see if that did what you wanted? If so, did it based...

bigdickmagee (6/29/2012)

---

Wow, this works like a charm, althouugh I need to read up some on tallys because I have no idea what it is doing from just looking at it.

I...

Don't tell us what you think you want, tell us what you do want.

It would help if you would...

From what I have seen of this, I just don't have 20 to 40 hours of free time to this for nothing. If I'm going to spend this kind...

First, I would take the information in that table with a grain of salt. Second, you will probably need to get a logreader to figure out what you need...

It is trying to convert the function name to a datetime value. You may need to do something more like this:

ALTER PROCEDURE dbo.pr_GetLastInterval(

@i_TimeInterval int = 15,

@dt_End_Block datetime =...

Edit: Deleted code, copied wrong stuff.

Here is a actual inline TVF spliter you can use in place of yours:

USE [Sandbox]

GO

/****** Object: UserDefinedFunction [dbo].[DelimitedSplitN4K] Script Date: 06/29/2012 09:00:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

Now, did you take the code that I posted based on David's post to see if that did what you wanted? If so, did it based on your initial...