Q&A for power users of Apple hardware and software
;with data as ( select id , postid , creationdate , comment , row_number() over (partition by id order by postid) [row] , rd.value from posthistory cross apply string_split(comment, ' ') rd where posthistorytypeid = 24 and charindex('|', comment) = 0 ) select * into #sugedt from data select top 100 * from #sugedt where row =1 and value <> 'Proposed'