Home Forums SQL Server 2008 T-SQL (SS2K8) Can't figure out how to get MIN/MAX dates per grouping RE: Can't figure out how to get MIN/MAX dates per grouping

  • AH of course!

    I see, using row number twice and subtracting to find the difference to create the desired output.

    Perfect, thanks!

    That never even occurred to me, I was playing around with multiple CTEs and isolating it and at that point I realized I had just gone off the deep end 🙂