Thanks for responding.

all other jobs perform the same if not slightly better.

this particular calls a stored procedure that basically does a massive select into from a...

I wasn't sure and i restarted the machine. the install still failed after a couple of restarts.

HI All,

thanks for the help. I got a solution which seems to work so I'll put it here in case someone else has the issue:

SELECT top 10 full_record,

CASE...

HI Jeff,

the original table does have a modified column so the idea is I would querying for data which has a modified date > getdate()-1

AGREED

HI Drew,

that's the output I want. thanks for that code. the thing is getting to that point.

i need to populate the table (@t TABLE(doc XML) with all new rows...

Hi There,

please see example of data below:

<AUDITS>

<Admin>

</Admin>

<provider_spells>

<Refno>123456</Refno>

<Action>UPDATE</Action>

...

apoligies, yes , XML . That was a type

thanks, unfortunately I can change the datatype.

HI There,

it looks like sql but is actually text

thanks for the reply.

the column contain a string of data. within that string I will see the following entries:

<new_pmetd_refno>4110</new_pmetd_refno> ...

Good stuff, thanks for the clarification