SQL Server doesn't support a JSON data type, in contrast to the XML data type which can be employed for storing XML.

When the XML data type is used for storing,...

• This reply was modified 2 years, 7 months ago by kaj. Reason: Removed direct reference to browsers and inserted SSMS instead

Absolutely, I have done that a few times.

You can use a script task or a script component to consume the web service. Then you can either store the response as...

Not sure if I have got the logic right, but please try this query:

SELECT CONVERT(CHAR(7),EOMONTH(J1.EntryDate)) AS Per, SUM(J1.RunTime) AS TReg, J2.TNQ
FROM Db1.dbo.WipLabJnl J1
OUTER APPLY (
...

Not sure if I have got the logic right, but please try this query:

SELECT CONVERT(CHAR(7),EOMONTH(J1.EntryDate)) AS Per, SUM(J1.RunTime) AS TReg, J2.TNQ
FROM Db1.dbo.WipLabJnl J1
OUTER APPLY (
  ...

Not sure if I have got the logic right, but please try this query:

SELECT CONVERT(CHAR(7),EOMONTH(J1.EntryDate)) AS Per, SUM(J1.RunTime) AS TReg, J2.TNQ
FROM Db1.dbo.WipLabJnl J1
OUTER APPLY (
  ...

That's too broad a question.

Application? What type of application?

Office-based application? Desktop application? Web application? Mobile application? Console application?

Even knowing that, it will be hard to advice, because we don't know...

It's valid JSON.  You could try either with two OPENJSON's or one OPENJSON and 2 JSON functions

/* two OPENJSON's */select SerialNumber, ojc.[value] as ChannelID
from openjson(@json) with...

Working with a combination of local and remote tables can be tricky.

You can try a few easy modifications and see if that helps:

1. Switch the joins (which by itselft shouldn't...

• This reply was modified 2 years, 8 months ago by kaj. Reason: elaboration
• This reply was modified 2 years, 8 months ago by kaj. Reason: typo
• This reply was modified 2 years, 8 months ago by kaj. Reason: Typo

I'd say it's because the CDbl function only expects one parameter value and you supply two.

I have no answer, but apparently you're not alone with that issue... 😐

SQL Server 2019 External Scripts Network Drive Access Denied

Is this what you're looking for?

DECLARE @MailMessage TABLE (
    "to" VARCHAR(100),
    "from" VARCHAR(100),
    "heading" VARCHAR(100),
   ...

• This reply was modified 2 years, 11 months ago by kaj.
• This reply was modified 2 years, 11 months ago by kaj. Reason: Added root element and XML output
• This reply was modified 2 years, 11 months ago by kaj. Reason: Changed output format type from XML to Plain, because the "pretty print" was otherwise lost

You are partioning on the same column that you do MIN/MAX on. This will not work. As I understand your requirements, you shouldn't do a PARTITION BY, since you want...

• This reply was modified 2 years, 11 months ago by kaj. Reason: Removed ORDER BY in the window function, since it's not necessary

Perhaps something like this?

SELECT
    RefDocNum,
    MAX(AcctDocNum1) AS AcctDocNum1,
    DocType1,
    LocCrdtAmt,
    LocDbtAmt
FROM 
...

Huh? I don't understand what you're saying. It doesn't...

• This reply was modified 2 years, 11 months ago by kaj. Reason: Typo

In a set-oriented language you return the whole set of values that are temporally equal toMight wan the min(date diff) over(patition by account) .

Look up Dr. Codd's T-Join for...

• This reply was modified 2 years, 11 months ago by kaj.