Thanks @jeff Moden

It did not email me your reply so I only saw this a few days ago. That code is interesting but I cannot use it unfortunately...

Thanks Jeff,

Yes there will always be one good row for the sequences where the expdate is the same. And it will be the one with the highest sequence. The way...

Ok apologies I am new to this. On another note how do you find a tables details, like column names and data type (for example in SAS you have proc...

I’ve added the option within the function itself and it’s working now. Everything I read online said I could not do that ??

sometimes You just have to try things even...

I tried that and it ran (unlike when I put the option in other parts of the code) but I still got the same error. Any ideas as to why?...

Can you show me on my code? When I try to add the maxrecursion it does not work

Use sand
Drop table if exists #testfunction;
Select b.*
into #testfunction
From ( select...

Thanks everyone,

It was a colleagues code he requested help on. I've send him the link for cluster indexes online and also wrote him your code @SSC Guru.

Also why is it...

Can you share a link of how to do that? It is a banks Database, do you think they’ll let that happen?

Is there any resources for learning UDFs? I have look online but I could only find basic introductions. I am keen to fully understand how I can best use them

Sorry I could not include the data it was a work project. I've simplified the CTE so now I don't need the lead so everything is working. I am going...

Is there a way to delete posts when you figure out your own mistake?

Resolved