Hi!
On SQL Server, I have some number of databases, where data are read into tables using pass-through queries to our ERP program. The data saved in those DB's are then used by other applications.
Currently I have a case, where I need to create a view based on data from 2 pass-through queries, which both are working really fast, and where saving the data into DB is the waste of time. So I had an idea I'd not prefer to check out on live server without consulting about it first.
Is it possible to run a query in SQL Server, where in WITH clauses are used pass-through queries directly? And when yes, then how exactly?
Edit: The header of thread must be 'Can pass-through query to be used in WITH clause' - I couldn't change it anymore!