Thanks for the help, recreated the agent task as a different user and it worked fine.

Cheers for the help.

Eugene,

Thank you so much, this works a treat. I was working along these lines however I was just adding the non merged rows outside the XML path and wondering why...

I think it must be a disk space issue. The cleanup wizard wasnt picking up and removing the old bak and trn files from the system. Its amazing how fast...

Many Thanks for your help, sorry about the poorly constructed xml. I will have a look at the links you passed on.

Thanks again,

Oliver

Many thanks, reduced times from 1min 7 secs to 4 seconds.

Really appreciate your help,

Oliver

Thanks Sean, will do

Hi,

Worked it out, added a new field for ordering:

SELECT 1 as OrderME,*

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportBlockColumnParam1](a.ID) b

WHERE a.ColumnType = 1

UNION ALL

SELECT 2,*

FROM [dbo].[TSC_ExportedColumnIds] a

CROSS APPLY [dbo].[udf_TSC_qry_ExportBlockColumnParam2](a.ID,4) b

WHERE...

Thanks for the help this makes sense. The query works considerably faster. However I have one issue. Each part needs to run in order e.g.

For the 1st ID - if...

Hi Dwain,

Thanks for the help, I made a few changes but the key is that I need to push the column_id variable to each function. How do I do this?...

Many Thanks Drew,

This works really well. The table was just a poor example of a larger table I was working on. Sorry about the inconsistencies. One question for you, isn't...

I see what you are up to here. This is a really neat method and will work it up. Thank you for sending over the CLR reference, I will check...

Thank you, this worked perfectly. In future I will provide test data in this way.

Thanks again,

Oliver

Many Thanks for your help, this is good to know. Will try the CLR route.

Cheers

Thanks for this, my CLR skills are non - existent but it is something I need to look into. I don't think such powerful query tools exist to do this...

Hi,

Many thanks for the break down. Sorry to bother you I am just keen to get my head round this.

Taken another look at it this evening. I made a...