Grasshopper beat me to it 🙂

Hi Jeff,

I did indeed.

I basically deconstructed the entire query and re-wrote it the way I would.

I believe the issue was caused by a join in the interior query. I worked...

Hi Matt,

Afraid this didn't work and am having exactly the same issue. I'll stick up some data for this tomorrow following Jeff's guidelines if I can.

Hi Matt,

Thanks for the reply. This is a query I've inherited along with an application and I'm still trying to understand a lot of it 😀

You should see some of...

.. but if customername and date are identical (and they will be in many instances), should this not sum to give 100?

I may have confused you a little by attempting...

The unique ID is not unique in this case because I am selecting from 2 different queries and using a union.

The problem is that it produces an output like this:

UID...

You can copy the DLL to the ReportServer bin directory, usually found here:

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

I've a feeling that the DLL may deploy itself to the ReportServer bin if...

Hi there,

Nice article - I wasn't aware of the need to create objects to represent your classes - I had previously just went for the myClass.myFunction method and this seemed...