Viewing 15 posts - 1 through 15 (of 18 total)
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...
August 26, 2020 at 12:50 am
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...
August 25, 2020 at 8:00 pm
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.
August 25, 2020 at 2:37 pm
@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 the schemas...
August 25, 2020 at 1:38 pm
@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...
August 25, 2020 at 1:30 pm
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.
August 19, 2020 at 6:51 pm
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...
August 19, 2020 at 6:50 pm
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...
August 19, 2020 at 6:49 pm
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...
August 12, 2020 at 3:01 am
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...
August 10, 2020 at 1:26 am
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...
August 7, 2020 at 10:57 am
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:
In this query, I am getting...
August 5, 2020 at 4:38 pm
Thank you pietlinden for this great response. Actually, the struggle was also conceptual and logistical and I am still struggling:
In this query, I am getting the counts for the entire...
August 5, 2020 at 10:56 am
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...
August 5, 2020 at 3:17 am
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...
July 14, 2020 at 8:26 pm