4 Replies Latest reply: Aug 24, 2016 7:53 AM by josh flory RSS

    Use custom SQL in Add Data?

    josh flory

      I want to just paste an SQL script into the Add Data area.

       

      I don't want to go picking a bunch of tables by hand, I just want to paste in my query.

       

      I can do that in the LOAD script area...but if I do that I can't manipulate table relationships etc... in the add data area (associations) or whatever.

       

       

      Is there not anyway to just paste a query into the tool and have it use that result?

       

      Am I forced to create views on my SQL server and then map to the views in Add Data???