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...

Hi Jason

I'm trying out your code using the...

Simon E Doubt (4/4/2014)

---

Have you thought of using SSIS and the RS scripting utility?

I developed a solution using that technique to render PDF versions of a specific report once...

I did read through this..

http://www.sqlservercentral.com/scripts/Miscellaneous/31733/

but I can't work out how I would loop through the list of people requiring emails and parse the parameters and emails from...