Here is one method - you can extend as needed:

$badFile = "C:\Temp\badfile.csv";
$goodFile = "C:\Temp\goodfile.csv";

Import-Csv -Path C:\temp\testfile.csv -Delimiter "|" -Header (1..12) |
    Group-Object -Property {$_.1...

If the totals are already aggregated this way - then you can do this:

   With currentYear
     As (
 Select t.Country
 ...

If the only values available in the result column are Y or N - you could do this:

 Select r.id
   From Response r
  Group...

In contract to @JeffModen's response - it is also possible that the client(s) are sending varchar parameters and all of those queries are using implicit conversions and full index scans.

Before...

To find out why a step in a maintenance plan failed - you need to view the maintenance plan history - not the SQL Server Agent job history.  To do...

Did you try running my example - or just the query?  You need to change the example to fit your tables.

What account is running the SQL Server service?  It seems that this account does not have access to read the local system to retrieve the list of available users.

Are you...

I think this should get you started (thanks to pietlinden for the sample data):

--EquipWorkOrderID/DateTm/Equip/AccountCode/Descr/Description/Resolution/Status/UserNm/Hrs
Declare @WorkOrder Table (
        EquipWorkOrderID INT
 ...

I do not see any issues, but I would use developer edition.

So what part of the outline are you having a problem with?  With as many different posts you have on this subject - I would have thought that you had...

If you create a text box parameter and allow any text to be entered by the user, then your SQL code could be as simple as:

SELECT ...
...

First - to get row count you can do this instead of count:

Declare @schemaName sysname = 'dbo'
      , @tableName sysname = 'Tally';

...

You can start with something like this:

Declare @pDelimiter char(1) = ';';

 Select tt.FileData
      , p01_pos = p01.pos
     ...

ROW_NUMBER() ???

Yes - you can host the databases on a separate instance and install only the reporting services components on the 'web' server.  This is quite useful if you are using...