Something like this. Calling your table 'table' is a really bad idea, because 'table' is a reserved word - that is why I have surrounded it with square brackets and...

• This reply was modified 3 years, 7 months ago by Phil Parkin. Reason: Code rendering made some words invisible

Please post what you tried and I will try to...

Here is one way. (For future reference, please note how I set up sample data in a form which can be cut & pasted directly into SSMS.)

DROP...

Are you trying to get something like this? (Untested and probably has error!)

SELECT pcx = SUM(IIF(tab.status = 'X', 1, 0)) * 100.0 / COUNT(1)
   ...

Welcome to the forum.

You need to tell us what the source data looks like in order for us to tell you how to achieve the result.

Alternatively, be more specific with...

The error message seems self-explanatory. Can you post here the parameter text which is resulting in the error?

Edit: why are you trying to modify the parameter name and not its...

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

Arrays do not exist in SQL Server, But strings can still be split and referenced by their ordinal ('ItemNumber' in the following).

This code relies on the existence of the legendary...

Jeff, that's a rather useful link, thanks for posting.

I have some suggestions:

1. Compare the files, understand the differences...

Would you please explain the required logic a little more?

Is this failing locally, in VS, on the server, or everywhere? Have you installed both 32- and 64-bit versions of the driver?

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
...