Save View results as Table? 1

[schusser]

Is it possible to create and replace a table as a result of a view? I have a view that does what I need, but cannot be exported as .txt as needed by the next user of the information. It is to be uploaded to a mainframe for use in their application.

Or will I need to create a table and update it?

Thanks in advance...

 

[pgtek]

Hi

Just create a temp table and insert the result of your view in it

cheers

pgtek

 

[SQLSister]

When you export data with the wizard, you have the option to use a query to choose hte data to export. Pick this option and copy the SQL for the view into the query window. Then you can use this to make the DTS package for exporting.