Q&A for materials modelers and data scientists
;with data as (
select top 1000
, row_number() over (partition by id order by postid) [row]
cross apply string_split(comment, ' ') rd
where posthistorytypeid = 24
and charindex('|', comment) = 0
where row = 1 and value <> 'Proposed'