1

Please login or register to vote for this query.

(click on this box to dismiss)

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'

view current version

edited aug 2 21

created aug 2 21 rene