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?

Well you will need to change the PLSQL into T-SQL, but is there a reason you cant just use the UPPER function?

SELECT UPPER('hello')

Just need to specify the DSN in the Data Source and UID and PWD go in the security screen

Install the Sybase ODBC drivers to your SQL server, create a DSN on the SQL server to Sybase, then use the standard ODBC driver type in the linked server configuration.