2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

select postid as [Post Link]
     , crt.name
 --    , text
 --    , JSON_QUERY(text, '$.Voters')
     , cv.userid as [User Link]
from posthistory ph
inner join closereasontypes crt on crt.id = comment
cross apply OPENJSON(JSON_QUERY(ph.text, '$.Voters')) 
       with (userid int '$.Id') cv
where posthistorytypeid = 10

fork query

edited mar 19 18

created mar 19 18 rene