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

      Alan