Thank you

Hi,

Can this be used, as implied by original post to deal with the following:

Select

sum(case when dd.BK_DepartmentTypeCode = '01' and dates.CalendarYearNumber = '2016' then 1 else 0 end) [2016Type1Att],

sum(case when dates.CalendarYearNumber...

Hi,

Can this be used, as implied by original post to deal with the following:

Select

sum(case when dd.BK_DepartmentTypeCode = '01' and dates.CalendarYearNumber = '2016' then 1 else 0 end) [2016Type1Att],

sum(case when dates.CalendarYearNumber...

Hi,

Can this be used before running a series of select queries against a table?

Or is this specifically about updates/deletes?

Q

@sean - Thanks for the swift response.

This worked when i put in into the query which selected the source data used for the table i presented (which was...

Thanks

Thanks.

I thought SSDT came with the developer edition, but if not i will download separately. I know that i need Visual Studio 2015 (at least) to go with the 2016...

Hi,

Thanks @happycat59

So would i do two installs in total then?

In one i would put as default ie localhost (SSIS, Queries and SSAS tabular) and the other a named...

:-D:-D

@thomas-2 - This was in reference to a linked article which states that:

"Users who have SHOWPLAN, ALTER TRACE, or VIEW SERVER STATE permission can view queries that are...

True. It is a difficult place to be as a developer not sitting within the DBA/BI team but interfacing with their DW.

It seems to be a life of workarounds................................................................

Thanks for your perseverance!

Select @test-2

Awesome. Though i will be seeing flying pigs before i think i will be allowed to do this as it seems it can show sensitive information such as passwords. 🙁

Ahhhhhhh.... so i can select the SQL code tag, then where it says "sql",

i insert my SQL between the "" and post?

Are there possibilities where they can extend rights within a specific database in the datawarehouse and/or is this all about how permissions are set up at the top level and...