Thanks for your reply. But when I am on any particular stage, all I have to hand is the StakeholderID for that stage - so I can't start with the...

That does it exactly. Thank you very much.

Thanks for your reply. This has just come up again and I still can't get it to work.

Say I have an email address like FredO'Shea@fred.cam

The apostrophe in that email address...

Thanks for your reply.

I do have the production database on a different server ... I can get to that and script out the tables, stored procedures, etc. if I have...

Thanks for your reply and help. I need to talk my client into allowing the install.

Thanks again for that. I just had to change ...

;with sortedValues as

(

SELECT FieldID

, WeekStart

,TemplateID ...

to

;with sortedValues as

(

SELECT FieldID

, CASE WHEN WeekStart IS NULL THEN -1 ELSE WeekStart END AS...

Sorry this has got so complicated. I understand the way you have suggested to determine whether StageBase is true. If we go past that and just consider this:

CREATE TABLE #tblFields

...

Here is where you lose me. Are you saying that you want to make sure that the max value of week start in each group is greater than the max...

Thanks for your reply. Adding a bit more to your code ...

SELECT #tblFields.WeekStart

FROM #tblFields

INNER JOIN

(select #tblFields.TemplateID

, #tblFields.BlockID

, isnull(max(cast(StageBase as int)), 0) as IsValid

from #tblFields

group by #tblFields.TemplateID

, #tblFields.BlockID) A ON...

Sorry, it's not easy to explain in words ... without a sketch or something - and my terminology is probably wrong.

Taking things one step at a time ...

in tblFieldss there...

Thank you for your reply. My apologies - I am an idiot. I failed to mention I need the EmailID returned as well. I have modified my code.

Edit again. I...

Thank you for your help.

Thank you very much.

Lynn Pettis (8/22/2014)

---

sku370870 (8/22/2014)

---

Sean Lange (8/22/2014)

---

sku370870 (8/22/2014)

---

Lynn Pettis (8/22/2014)

---

Sean Lange (8/22/2014)

---

brad.mason5 (8/22/2014)

---

Not sure if this is what you are looking for. This is assuming OrderID is the correct order...

Sean Lange (8/22/2014)

---

sku370870 (8/22/2014)

---

Lynn Pettis (8/22/2014)

---

Sean Lange (8/22/2014)

---

brad.mason5 (8/22/2014)

---

Not sure if this is what you are looking for. This is assuming OrderID is the correct order you want.

SELECT TaskID...