This should be done in the presentation layer (Excel, SSRS, PowerBI etc).

Try this

SET @query
    = N'select * into #FinalResult from

(select Name, ' + @cols
      + N' from (select name,quantity,itemname from...

Have you tried using SELECT INTO?

Try this:

SELECT
    q1.success
,   q1.timestamp
,   q1.date
,   q1.base
,   q1.rates
,   q1.unit
,   q2.USD
,   q2.XAG
FROM
...

Other than thanking me, your post appears to have ignored mine.

Please describe why the idea I suggested is not applicable in your case.

Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

And when I hit submit again, it...

Perhaps this example explains what is happening?

SELECT AVG(x.n)
FROM (VALUES (1), (2), (3), (5)) x (n);

SELECT AVG(CAST(x.n AS DECIMAL(19, 6)))
FROM (VALUES (1), (2), (3), (5)) x (n);

I've read through your code a couple of times and I'm still not sure exactly what it is doing, but I can offer some input.

You appear to be building a...

I cannot see a question here.

The problem is that I can’t seem to find the menu this person is referring to.  Can anyone else give any extra information on this?  Ideally with screenshots?

The link you...

Product.ProductDetails is what you should be including in your query. Including database name is usually a bad idea (if you ever rename the database, the query will no longer return...

All tables in SQL Server belong to a schema. What problem are they causing you?

OK, in my opinion, the problem does not lie with OPENJSON. The following is valid JSON:

{
  "Produtos": [
    {
    ...

Can you provide some literal sample content for @json, please. For many people, sp_OACreate and other OA modules are blocked for security reasons.

This chunk of C# is sufficiently complex that I doubt anyone here will produce a modified version for you. But I will provide some comments:

1. It seems obvious, but why...