Actually, I made a mistake - I didn't mean to include SSRS. That was my bad.

I had thought that a good SSIS designer would also have to be a good...

Thank you for both of your answers.

To provide a bit more context: I am looking at someone who is an absolute expert in data modelling creating very efficient and elegant...

• This reply was modified 4 years, 3 months ago by  Mysterio.

Thank you again and I certainly agree with both posts/replies.

For sure, will rephrase differently in the future.

And it is a good consideration to give apps least privileges.

@greg Edwards-268690 Thank you very much for this answer. It is a good way of managing it and makes it elegant, however, unfortunately I cannot move or change...

@scottpletcher: Thanks so much Scott for providing this answer. This actually worked, and I believe this was the first/only technical answer that wasn't an HR answer!

I also gathered...

You are correct. However, there are multiple schemas (actually too many). So the solution shouldn't really be permitting a single schema.

I am really not sure what the best way is.

The issue remains the same, regardless of AD Group or a user. What different would that make? You'll run into the same issue: how best to assign permissions. Whether that's...

I don't believe that these replies are accurate.

First, the question of getting fired is outside of the scope and not relevant to the question being asked.

Second, I was able to...

What I dislike about PIVOT is that you have to repeat UNIONs several times depending on the metric. This makes it difficult to change and error-prone as you may forget...

Certainly this question will sound stupid: is IIF a new SQL command? I do not see it any of my (somewhat old) SQL books. I looked at the MS...

Use of SP is not allowed since we are analysts and without exec permission.

Sorry didn't know that would be useful. Here.

CREATE TABLE [dbo].[ProductOrders](
[ProductCategory] [varchar](5) NULL,
[ProductSubCategory] [varchar](5) NULL,
[Total...

Thank you for the great responses. I think there is a miscommunication here:

now the query works, but I am not sure if I understand it:

Conceptual:

In this query, I am getting...

Thank you pietlinden for this great response. Actually, the struggle was also conceptual and logistical and I am still struggling:

Conceptual:

In this query, I am getting the counts for the entire...

wouldn't the answer you gave apply an internal cast? So wouldn't it be the same as if we specify an explicit cast? I mean, if the formats differ, it should...

How are these tables replicated?

It's a propitiatory process, and it is a complete blackbox to us. So we get refreshed data, but we are not allowed to see the actual...