Thanks for the help Phil, it was much appreciated.

I've resolved by virtualising the union results in the cte and adding another select - this may slow the whole thing down a touch but in truth the query will...

Hi Phil - this is adding an ID of zero into the 'unioned' result - I need the second part of this union to effectively inherit the ID from the...

Hi Phil, that has worked a treat .. I used the same convention but used a CTE to create 'virtual tables' since Tables A and B did not exist in...

If you work out what the last Monday was, and what the first Monday in August was, you can do a datediff in weeks to get the week number...

Thank you all for the ideas and the work! There is brilliance here methinks LOL.

I can just about work out how Dixie's Tally works, and Scott's just breaks my brain...

Aye, I started with getting the datepart week for 01-Aug and subtracting or adding as required but the leap years got me, and of course the standard week number also...

As a best estimate, that was a good effort! 😀

I altered the query to bring back a little more info to check if the answer was as hoped...

SELECT a.ID

, a.EntityType

,...

Thank you both for your help - I'll try and setup a test with real data 🙂

Just returned to work and will try both of the suggestions - thanks for taking the time to offer solutions guys, it is much appreciated.

That did it, thanks Luis

Getting closer...

I'm able to output...

xg-14-A2-4xZS, ZS, ZS, ZS

xg-14-A2-6xZS, ZS, BP, BP

xp-14-A2-1bxLW, LW, LW, LW

xp-14-A2-1xLW, LW, LW, LW

xt-14-A2-2xSBS, SBS, CW, CW

xt-14-A2-3xSBS, SBS, CW, CW

but now I need to remove duplicates so...

I have read part two but couldn't see how it would fit this situation, but...

Hi guys

Have this procedure running now, thanks to your help, but I do still have one problem with it:

If I set the waitfordelay to anything less than 15 seconds the...

Jason Selburg (4/8/2014)

ldanks (4/8/2014)

Hi Jason

I'm trying out your...