result - restarting, then installed SP2, then CU2 fixed the issue!

Cheers

This seems to be the same issue.

I will try the restart and the SP2 update.

[urlhttp://www.sqlservercentral.com/Forums/Topic1588898-3411-2.aspx][/url]

I hope this resolves.

dump file attached, I hope it helps

When I take the json from the browser and put it into a variable the json_query works fine. It appears to be something to do with the get http request.

declare...

maybe some mix up with google - amazon said there were two 🙂

https://www.amazon.co.uk/Superforecasting-Science-Prediction-Philip-Tetlock/dp/1847947158/ref=sr_1_1?ie=UTF8&qid=1468223053&sr=8-1&keywords=superforecasting

Thank you, I have been so caught up with the issue I must have mixed up the isbn's! Thank you so much for helping me with the fix, tested it...

it's strange, when I try with a different ISBN it works fine e.g. 0273767062

3 authors are returned?

really odd

Thank you, this works in your example but when I pull it from google it doesnt. Please try with the full script below. (I will replace the api key later).

CREATE...

some progress, if I only take a portion of the json it works fine?!? only problem is that I cannot take just a portion

declare @json varchar(max)

SET

Thanks for the advice and your help have a good sunday afternoon!

Hi,

Thanks for all your help, I took the example content from wikipedia but all the content I want to put into a table is in the format. Essentially I am...

Hi, thanks for the advice, I will try with Python as I am more familiar with python than c# and see how I get on.

Many Thanks,

Oliver

Many Thanks will give this a go.

Thanks for the help.

Many Thanks this works perfectly. I really appreciate the help that splitter is going to be so useful going forward for other tasks. It seems that cross apply seems to...

Thanks for the reply. The output I would like is to return the ID for the rows which have a continous character string longer than say 60 within the string,...