RE: RE: December 2019 - Monthly Steem Report 📝📊
You are viewing a single comment's thread from:

RE: December 2019 - Monthly Steem Report 📝📊

Words
50
Reading
1 min
Listen
Play
7y

I used this :)

DECLARE json@json NVARCHAR(MAX)
SET json@json = N'JSON HERE'

SELECT * FROM
OPENJSON ( json@json )
WITH (
Timestamp varchar(200) '$.timestamp',
Curator varchar(200) '$.curator',
Author varchar(200) '$.author',
Amount int '$.int_amount',
Precision int '$.precision'
)

Then a little fiddling in excel.

Thanks for the link and encouragement :)

@abh12345: I used this :) | Ecency