Its very wrong!

Used recursive cte to build off the anchors that had min tradesdateorder from a unique accountno, instId

Used recursive cte to build off the anchors that had min tradesdateorder from a unique accountno, instId

I used a CTE to get the minimum date of each group, then a recursive cte to build on that. There are some problems with my solution, it assumes that the first row after each minimum date meets some criteria.

I used a CTE to get the minimum date of each group, then a recursive cte to build on that. There are some problems with my solution, it assumes that the first row after each minimum date meets some criteria.