That's just some sample script. I believe someone put the DROP statement in there just to clean up.

I did add a UDF called DelimitedSplit, but can't figure out how...

Sorry...got pulled into some other projects.

I found that the code is working as it should when using a "real" table with thousands of rows. The output looks good,...

I still don't know if it's practical to move around that much data, but at least we have some fat WAN pipes. One environment generates over 300MB/day in CAS...

The data is imported from a flat file. Nothing tricky here - just mapped the fields. I still haven't finalized the process of getting the logs copied from...

This is looking very promising. Thank you.

As for the output, I'd prefer that it not include the name of the delimiter, only the value. i.e. "Ping" instead of...

Yes. The parameters to parse are:

Cmd=

User=

DeviceId=

DeviceType=

Log=

Ampersands are placed before each, except for the first one. Here is a condensed example:

Cmd=Ping,&User=Me&DeviceId=MyDeviceID&DeviceType=MyDeviceType&Log=MyLogEntry

Another from a different device may look like this:

User=Me&DeviceId=MyDeviceID_with_more_characters&DeviceType=MyDeviceType&Cmd=Ping,&Log=MyLogEntry

For...

Just tried the suggestion using the REVERSE commands and it returned too much data. I need it to stop when it gets to the next delimiter (which were @1:...

To be honest, I haven't checked the 2nd suggestion offered to see if it works. I did read the article about the best way to post code on the...