jeudi 7 janvier 2016

How can I insert result from stored procedure to a new table?

I have a SP that returns a SELECT (can't convert it into a view because it does a little bit more than a SELECT). I want to put the result into a new non temporary table.

So far this is what I've tried

select * into newTable from (StoredProcedure) t

But it returns me

Incorrect syntax near ')'.

Aucun commentaire:

Enregistrer un commentaire