If you're fancying a change of pace the Slack community is forever increasing (https://aka.ms/sqlslack) although that is also again not without its limitations, as there's over 16k people in...

So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a host of others that...

JCelko

Thanks for your reply....but your coded response does not meet my expected results  (which I posted)

Other posters have resolved the problem for me.

• This reply was modified 4 years ago by J Livingston SQL.

Thanks Homebrew....

it was the "trick" CASE WHEN LAG(t_type) OVER(PARTITION BY t_id ORDER BY t_date) = t_type THEN 0 ELSE 1 END AS IsStart that Mark used was the bit I...

Thanks Mark

yup  .......

Never knew about that Jeff......thanks muchly

yup  .... and the...

• This reply was modified 4 years, 1 month ago by J Livingston SQL.

maybe this will help?

if you paste code into https://www.dpriver.com/pp/sqlformat.htm  (Instant SQL Formatter) by default it breaks the brackets out so it is easy to follow...other formaters are available <grin>

This reply was modified 4 years, 1 month ago by J Livingston SQL.