Posted by Ed Murphy on 11/30/06 11:30

Dia wrote:

> I struggle to get this going i would like to insert data into 2 tmp
> tables in a view.
> If i run the code on it's own it works perfectly until i want to create
> a view it complains about the INSERT

You need a stored procedure, not a view.

• Next in forum: Re: Inserting into a tmp table using a View --- Please help using SQL Query Analyzer
• Prev in forum: Re: SELECT UNTIL ?
• Thread view: Re: Inserting into a tmp table using a View --- Please help using SQL Query Analyzer

[Reply to this message]