Yes, notifications seem to be working again.

I recommend that you use the visualiser to decide on which columns to include in one or more row/column datasets you wish to extract and take it from there.

JSON's infinite flexibility is also its downfall in cases like this. There is no SELECT * with JSON data, because the data can be very hierarchical.

If you paste the JSON...

It's not clear exactly what you are trying to achieve, but this is a start, showing how you handle JSON in T-SQL. If your desire is for something more complex,...

You have provided an error message, but not asked any questions.

I am no longer receiving e-mail notifications when someone responds to a post I am subscribed to. Is it me, or is this affecting others?

The fact that you wish to use an OLEDBCommand suggests that you wish to put this in a data flow, is that correct?

I presume that you realise the impact of...

Nothing to worry about. SELECT queries merely read data, they do not update it.

Winscp is another decent option for the FTP client.

hmm.. for some reason it says that the last post by me but I can't see it

UPDATE: weird.. I could see only 3 pages and once I posted this...

Thanks for verifying.

In addition, it seems that I...

Borrowing Jeff's code a little, here is another version:

DECLARE @Year NVARCHAR(50) = N'201901';
SELECT STUFF(@Year, 5, 0, '0');

Not only is the NVARCHAR() datatype a terrible choice, but calling...

A very similar question of yours has already been answered here.

Thanks Des, that is much tidier.

This gets you most of the way there. I have not yet worked out how to handle the space in 'Case ID' though.

DROP TABLE IF EXISTS #SomeXML;

CREATE...

• This reply was modified 3 years, 11 months ago by Phil Parkin.
• This reply was modified 3 years, 11 months ago by Phil Parkin.