And why you think it wont work? or is it that the locations is more than those you mentioned? 

And in any case why do you need it on...

SQL then 

declare @Table table
  ( id   int
  , location varchar(50)
  )
insert into @Table select 1 , 'west'
insert into @Table select...

sorry - misread and though you after some SQL - on SSRS I don't know

Eric, did you run SSMS as administrator ON the server itself? or on your workstation?

Can you also tell us how many rows each table has.

From what you said before I would think GL_Transline is the big table, but GL_Source  I would be inclined...

I notice that your scripts are missing both compression and filegroup information - just to confirm could you please run the following script and supply us with the output.
And...

message is quite clear - access denied 
the user SQL Server instance is running under needs access to the...

I've seen that happen when there is a tiniest time difference on the clock vs domain server. Setting up a dependency on the time service can solve the issue if...

yeah.. with a totally different error 

Send-MailMessage : The SMTP server requires a secure connection or the client was not authenticated. The server
response was: 5.7.0 Must issue a...

That falls under the category of standards (company) and where none exist personal preference.

On my case standards (and personal preference) are
- tables always aliased
- select, from...

is this what you expect?

if object_id('dbo.ranks') is not null
  drop table dbo.ranks;

create table dbo.ranks
  ( name nvarchar(50) null
  )
  on...

Apologies for my previous post - Missed the fact that the plans were attached.

Agree with Grant - some implicit conversions around suser_name (all but one) but nothing jumping...

ahhhhhh... all queries are based on which user runs it.


uzsakymai.dbo.L0_BP where L0_vart = suser_name()

the above style is all over the place - so...

The sample provided follows standard definition for usage from mainframe style extract files - or PC Cobol files that follow old conventions.
But not just those follow these - I...

pseudo code

read sharepoint list - load onto datatable Invoices

using dbconnection to sqldb -- using transactionscope
{
create temp table (#invoices) -- execute nonquery
...