Using Standard SQL (not TSQL or other flavors), how can the string below be parsed so as to pull out each event element so as to place the info into a table?
[{"Event":"start","EventDateTime":"2015-09-15T03:45:16.681428Z"}, {"Event":"process","EventDateTime":"2015-09-15T03:45:16.681428Z"},{"Event":"end","EventDateTime":"2015-09-15T03:45:16.681428Z"}]
The final result ought be like this:
Event | EventDateTime
start | 2015-09-15T03:45:16.681428Z
process | 2015-09-15T03:45:16.681428Z
end | 2015-09-15T03:45:16.681428Z
Thanks!