Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

Question on Pass-thourgh query capabilities...

I want to run a pass-through query because it will run SQL faster on the server.  However i want to use the results returned to make a new table in CURRENT datatbase and not on the sever as i do have permissions want the table locally.  

how do i get the Insert into to create a table in the current db
0
david_88
Asked:
david_88
  • 2
  • 2
2 Solutions
 
jmoss111Commented:
Use the pass through as source for a make table query
0
 
david_88Author Commented:
does that mean i have to create 2 querys 1 for the pass-through and then 1 for the make table?

thanks
d
dave
0
 
jmoss111Commented:
That would be correct
0
 
datAdrenalineCommented:
If you want, you can just create ONE Query and utilize an ODBC connection string inside of the Make table SQL Statement ... how complex is your PT query? .. can you post the SQL statement for it?
0
 
david_88Author Commented:
got it to work both ways many thanks :)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now