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

Dia wrote:

> 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

So far, we've only seen what you want to insert into the temp
tables. We need to also see what you want to pull out of them
in the end, and then we may be able to rewrite it in a form
that can be used as a view.

• Next in forum: Re: Fiscal year search
• 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]