Multiple Connect Strings - SQL Server

[#1]

Hi All,

Is it possible to connect to two different servers within the same SQL select statement

The script reads something like this

$(Include=$(vConnectionFilePath));

SQL Select a, b, c

FROM server.dbo.tablename i

LEFT JOIN server2.dbo.tablename j ON i.a = j.a and i.b = j.b

Essentially how can you tell qlikview to change the connection string or include a different connection string within the a left join of a sql select statement

Your help is much appreciated

Cheers,

Byron

[flipside · Accepted solution]

Hi Byron,

Not as far as I know.

You could have server2 as a linked server on server1 (or vice-versa) SQL server side to allow cross-server queries OR make two separate connections in Qlikview and make the join in Qlikview.

flipside

[#3]

Hi Mate,

I was being an idiot Yes the linked server worked like a charm

Thank so much for your response

Cheers,

Byron