Home Forums SQL Server 2008 SQL Server 2008 - General Inserting Results from SPROC into table RE: Inserting Results from SPROC into table

  • June 28, 2013 at 8:13 am

    #1628311

    tstagliano (6/28/2013)

    Thanks for the information but i dont what the table to be a temporary table in the tempdb database. I need it to appear in the ConstarOLAP_PROPHIX_FactDB where the SPROC is running

    I specifically mentioned you could use permanent tables, but it might not have been clear enough.

    Which target able you use is up to you, whether it's a temporary table a permanent table that already exists, my snippet was only to demonstrate how to insert the results of the openquery data into a table so it can be used in other queries.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!