Posted by Dia on 11/30/06 11:39

Ed Murphy wrote:
> 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.

I need a vew to link into a query in Access for a report, so it's not
possible to do this in a view???

If not then i'll have to work my way around running a stored procedure
BUT would really settle for a view

• Next in forum: Find 2nd Working Day
• Prev in forum: Re: Inserting into a tmp table using a View --- Please help using SQL Query Analyzer
• Thread view: Re: Inserting into a tmp table using a View --- Please help using SQL Query Analyzer

[Reply to this message]