If you are familiar with PowerQuery, another possibility would be to create another spreadsheet which consumes the data from the original spreadsheet and does some manipulation in the process. Your...

TRANSLATE not available in 2016.

Jeff - that's what I am doing now, just using Replace(). I wanted to know if there was a better way to do it and so far it looks...

Neat solution, but I disagree with this comment:

it happens often that you need to save a list of single values/parameters that are valid, temporarily or stably, for the whole application.

In...

It's an ungainly piece of code, but I think it gets the right results.

SELECT ssh.id
      ,ssh.OrderNumber
      ,ssh.RelayPoint
...

Sorry to keep modifying this response. It's taken me a while to formulate a question I am happy with.

In your sample results, we see XN78/980.

The latest row for this combination...

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

Yes it should be possible.

(condition 1) && (condition 2)

I have a query in mysql I have created a account with test@localhost and i want to access the particular database where I have given access to the db...

Sure you can. If you add this WHERE clause to my query, it excludes any rows containing invalid JSON:

WHERE ISJSON(sd.SomeCol) = 1;

If you want to identify the...

Why not just make a backup of demo_1 and restore it over the top of demo_2?

Something like this?

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    SomeCol NVARCHAR(MAX)
);

INSERT #SomeData
(
    SomeCol
)
VALUES
('{"changedAttributes":[{"logicalName":"line1","oldValue":"street1","newValue":"street2"},{"logicalName":"city","oldValue":"City1","newValue":"City2"},{"logicalName":"phone","oldValue":"123","newValue":"345"}]}');

SELECT sd.SomeCol,oj2.*
FROM #SomeData sd
CROSS APPLY OPENJSON(sd.SomeCol) WITH (changedAttributes NVARCHAR(MAX)...

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

Add a derived column in the dataflow and set its value to the variable. It will be available for mapping.

Fed? Brain? I hate to think what you would call me.

OK, my point was that if the Code is already a candidate key in a table, why not throw away the Id and make Code the clustered PK? Could give...

Do the Id columns in these tables perform any useful function? Based on what you've posted so far, it looks like there's an argument for removing them ... or maybe...