Hi Mark,

I have spent the last couple of hours looking at your code and I cant work it out, if you could place a few text pointers around that would...

I changed the code to this to sort that change. Is there any problem with this?

-- identify rows with/without overlaps

;WITH SplitData AS (

SELECT a.*,

Parent = CASE WHEN EXISTS (

SELECT...

Thank you very much for this. I am slowly working through this.

Currently though I dont class two rows one row ending and the other row starting on the same number...

wow, is amazing. thank you so much.

I will now try and understand what you have done here. I dont really understand how you are comparing more than one row at...

Thanks for that, something to look forward to when we upgrade.

Sorry worked it out, if I PRINT instead of SELECT it shows nicely.

Many Thanks,

Oliver

Thank you very much for the quick reply.

Just a quick one, does the Line Feed not display in the SSMS results pane? I just get one long line at the...

yes you can using html - some is supported under 'interpret html tags'.

Thanks.

Oliver

much appreciated, will give this one a go as well.

Many Thanks,

Oliver

Thank you so much, I really appreciate the help. Will definately read up on partition by and ranking functions. Sometimes just finding what the relevant functions are called is half...

Already on this case. The new system is much better, but cleaning up 5 years of bad practice is going to take a bit of effort.

Many Thanks for your help,...

Yeah I will give this a go and see if it helps.

Many Thanks,

Oliver

Thank you for the help on this. I am two hours into running this query but I guess it's going to take a while to run against 90000 notes, and...

Thank you for the help on this, I am running this now. Looks like to run through 90,000 rows of varchar(max) data and comparing against 250,000 products its going to...

Thanks for the help, I can't help but think there must be a smart way to do this. I fear thatnif I go down the cursor route it is going...