Thanks for the reply, Phil! I think I could handle a simple query like that as well. Where it starts getting rough for me is when there are [x]...

varchar cause there are letter in it ...

Wow, I can see why your life is miserable! 🙂

I believe that I could do it in SQL, but it would take a significant amount of effort.

If you were to...

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

You've been here long enough to know about providing your sample data in a form which can be pasted into SSMS (with relevant CREATE TABLE and INSERT statements), rather than...

What is the datatype of the column 'status_count'?

We have assumed that it is an integer, but I suspect that it is not.

What happens when only one of the columns has an image?

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