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...

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 3 years, 3 months 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 3 years, 3 months 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...

• This reply was modified 3 years, 3 months ago by  J Livingston SQL.

Please provide details of your expected answer based on the demo data provided.....prevents any confusion on my part <grin>

Hi...just wondering why you would want to create a table with just one row from these results?

Also....what do you want to record when the postcode column is just an empty...

Well, after a 3 year absence I decided to take another look at SSC........Nice to see a lot of the names I remember still posting.

Am no longer earning with SQL,...

• This reply was modified 3 years, 3 months ago by  J Livingston SQL.

maybe read this https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum

and repost....?