logic implementation in sql

Hi Dre,

Does Patrick's sample query helpful for you on this issue? If the issue persists, please post the detail information about your issue, so that we can make further analysis.

Regards,

---

Charlie Liao

TechNet Community Support