Please do not disturb.

Watching the World Cup and cheering for Mexico!:-D

Just correcting the IFCode to make it easier.

Why do you have a Parent and Child in different tables? Should I assume that it's not a hierarchy but a header-detail?

Could you include the deleted column on your PK...

Had the same problem and couldn't log in for a while. Seems to be working now.

Order in a table is not guaranteed. Actually, it does not exists in a logical sense.

You could force it with an identity column and being sure the inserts follow...

The inserts don't match the table definitions.

TOP clause accepts variables and expressions.

Example:

SELECT TOP(DATEPART( HH, GETDATE()))

*

FROM master.sys.all_columns

I'm not sure if that helps you because I'm not sure on how do you want to...

If you fix the data import, you don't need to work that hard on the...

Did you even try to change the SSIS package to avoid all these complications?

There's no need to make that extra work with the date. You need to work with the run_duration column because it comes in format HHMMSS as well.

selectsjh.Job_ID,

...

Have you tried MERGE to avoid doing this in 2 steps?

Thank you for the feedback. You had the right idea on how to do it, I just helped you to get all the way there. 😉

Andrew Kernodle (6/12/2014)

---

Yep, we're in the same boat as far as compatibility and versions go. We're technically not supposed to be using 2008R2 by the vendor's contract (2008 is...

Fair enough. I thought you only had digits.

Check for the following. 😉

WITH SampleData AS(

SELECT '00345.0001' code UNION ALL

SELECT '02345.0123' code UNION ALL

...

cbrammer1219 (6/12/2014)

---

I have attached a flatfile with the data I am processing in SSIS and inserting into MitelCallTrace, then parsing it and inserting it into CallTrace.

I have posted the create...