The OP doesn't give us a lot to go on here, but I have (bad) feeling that those date columns are subject to change, thus the need for some "D-SQL"...

The fact that you haven't set it may be your answer, and thus SSRS is using the default. Why not try setting the value to a figure in your config...

Also, what is the need for your LEFT JOIN to the table DB1_GroupEmployees? You don't reference the table in your SELECT or WHERE clause, and the fact that...

Welcome to SSC.

When posting T-SQL questions, you need to ensure you provide DDL, DLM and expected outputs. We don't have access to your data, Server, etc, so simply...

If your column names are always in flux, then how are you proposing you INSERT data into them if you don't know what columns are going to be present. You...

This is a (Microsoft) SQL Server Forum, not MySQL. You'd be better posting on a website dedicated to MySQL, or (as much as I dislike it) Stack Overflow for an...

I assume you're logged in with an account with sufficient privileges to create and/or change a login?

So, based on your (couple...