No, you'll need to generate multiple reports and export each separately. Exporting a single report does not create multiple files, it creates a single file. A page break inserts a...

I'm not entirely sure what your question is here. The only thing you ask is (and I'm paraphrasing) "Is what happened what you expected to happen?". Well, you said you...

What have you tried so far? I suggest having a look at the documentation on COUNT: https://docs.microsoft.com/en-us/sql/t-sql/functions/count-transact-sql?view=sql-server-2017

I had this problem with a few work PC's back in April. The solution? I rebuilt all 3 PC's, starting with a reinstallation of Windows 10... Sorry, not much help...

Is that expression in your WHERE or SELECT? Dates don't have any kind of stored format, so using a WHERE clause with the format MM/dd/yyyy could yield very odd results,...

Why can you not, instead, grant the AD Group Execute permissions on the object? Is the dynamic SQL calling objects owned by other users, or another database?

Also, are...

A quick google of 'Entity Framework "DUMMY_VAL"' returned few results; one of which was this very topic. Sounds like somewhere in your application that's the query that is being used;...

You can still delete rows without a relationship in your database (although I still suggest you build that relationship).

It might be quicker, however, to actually delete the records...

Ahh, so you mean an installation of Windows without a Graphical user Interface; very different to saying "non-desktop windows", which implies Windows designed for something other than a Desktop PC.