5 Replies Latest reply on Aug 27, 2015 11:23 PM by Steve Martin

    Can I dynamical pass a MS SQL server name in custom SQL ?

    Alan Brady

      Hi I have a MS SQL server with a linked server set up to many other servers.

      I have a custom sql that I want to dynamically change to point to a different server for example



      SELECT *


      FROM [LinkedServer].[DataBase].[Schema].[Table]


      And I want to dynamical pass the server name something like this


      SELECT *


      FROM <Parameters.Server>.[DataBase].[Schema].[Table]


      However this is not working and I keep getting errors can anyone tell me if this is possible with Tableau


      Many thanks