Grant view definition on the schemas the developer is allowed to see or the database.

Connect to SQL Server When System Administrators Are Locked Out

As H4K said, you could just leave the developers with BIDS and get them to develop reports in BIDS, ensure they work as intended, then they can give you the...

What error are you getting?

what do you want the output to be?

Then there is no data for that particular empcode.

Please provide DDL, sample data and expected outcome.

PM from OP

if you have remove the line detailing into #temp then you have not provided the...

remove the into #temp line or select out of the #temp table after doing the insert.

also depends on what else you are doing to the #temp table after the data...

the output of that is only the rows affected message as your not selecting anything out, your selecting into a table.

http://www.geminiplatform.com

Seems to tick most of the boxes for us.

Thanks Lowell, I had seen something on Zendesk on my searches, but nothing that passed me over to that link. Will see if the developers here can pick apart...

Can you post the DDL and some sample data with expected outcomes, its unclear from your initial post what the table structure is.

need to grant the account which is running sql agent on the secondary server access to the share, or make the share available to everyone.

Generally in the environments I have worked in the past, only the DBA's have had the skill set to develop SSRS reports, so we controlled everything.

We also didnt allow the...

Have you tried using First and Last instead of Min and Max?