INSERT SELECT?

Hi all,
I am trying to run an INSERT SELECT statement. This should be an easy
query!!!
Code:
SET IDENTITY_INSERT asmt_v1_areas ON
INSERT INTO asmt_v1_areas ('asmt_v1_area_id','name','mid') SELECT
assmnt_area_id, name, mid FROM assmnt_areas
When i try to run this query i get an error message saying invalid object
name 'asmt_v1_areas'
This object does exists and i can issue select statements on it.
I assume i have some kind of syntax error.
Can someone enlighten me'
Cheers,
AdamAdam Knight,
Can you check the object's owner?. SQL Server is looking for the table
dbo.asmt_v1_areas. The table should have an identity column.
AMB
"Adam Knight" wrote:

> Hi all,
> I am trying to run an INSERT SELECT statement. This should be an easy
> query!!!
> Code:
> SET IDENTITY_INSERT asmt_v1_areas ON
> INSERT INTO asmt_v1_areas ('asmt_v1_area_id','name','mid') SELECT
> assmnt_area_id, name, mid FROM assmnt_areas
> When i try to run this query i get an error message saying invalid object
> name 'asmt_v1_areas'
> This object does exists and i can issue select statements on it.
> I assume i have some kind of syntax error.
> Can someone enlighten me'
> Cheers,
> Adam
>
>|||Don't use quotation marks around column names - instead of:
INSERT INTO asmt_v1_areas ('asmt_v1_area_id','name','mid')
use:
INSERT INTO asmt_v1_areas (asmt_v1_area_id, name, mid)
"Adam Knight" <dev@.brightidea.com.au> wrote in message
news:u6bzvfP2FHA.3788@.tk2msftngp13.phx.gbl...
> Hi all,
> I am trying to run an INSERT SELECT statement. This should be an easy
> query!!!
> Code:
> SET IDENTITY_INSERT asmt_v1_areas ON
> INSERT INTO asmt_v1_areas ('asmt_v1_area_id','name','mid') SELECT
> assmnt_area_id, name, mid FROM assmnt_areas
> When i try to run this query i get an error message saying invalid object
> name 'asmt_v1_areas'
> This object does exists and i can issue select statements on it.
> I assume i have some kind of syntax error.
> Can someone enlighten me'
> Cheers,
> Adam
>