Brian, just to let you know, I got it to work! The client had not been uploading the correct version of the rdl. I had manually changed one to 2010...

• This reply was modified 6 months, 3 weeks ago by  Frank Cazabon.

Thanks but unfortunately I am not using Visual Studio, just using their report builder which is version 12.0.6179.1. Their SSRS version is the same number 12.0.6179.1.

The part I don't understand...

My client has version 12.0.6179.1

According to my client, both the server and the report builder they have are 2014. My version of Report Builder is 15.0.20073.0. I'll ask them to verify the version number.

I...

MadAdmin (3/17/2016)

---

Are these queries perhaps to populate...

John Mitchell-245523 (3/10/2016)

---

Frank Cazabon (3/10/2016)

---

Be careful - you don't (necessarily) want to turn off parallelism on the...

Thanks Chris

Thanks, it's giving me an error when I include the

OPTION (MAXRECURSION 0)

I have left it out, I hope it's not important 🙂

Thanks Chris, that CTE is incredibly faster!

Is it possible to use CTE in a view definition? All this code relies on this view so it would be easiest if...

John Mitchell-245523 (3/10/2016)

---

Six seconds doesn't sound unreasonable for that lot on a table that size. What maintenance do you do on your indexes? Have you tried running the...

This was the errorlog they sent me:

2015-11-28 11:44:33.23 Server Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (Intel X86)

Jun 28 2012 08:42:37

Copyright (c)...

I'll try to connect to the client today and pull the event log.

Hmm, nobody ever seen this before or have I not given enough detail?

Thanks to all, especially the link to the bug when restarting the service.

Thanks,

I'll probably end up doing this in my application rather than in the database.