I've got a problem trying to insert data into an empty table
I have an empty table that I need to fill.
I want to use a created view where I have the information i need to use to fill the first table. So I executed the following

insert into PO_expectedResult_CES (TYPE_CES, SystemStartDate, RECEIVERNO, quoteuser, PO, POREGID, item, VENDOR, RECEIVED, WHSE, InvNum, InvDate, FranchiseId, MainSt, Frequency, InvoiceStartDate, InvoiceEndDate, WarehouseOpenDate, WarehouseCloseDate, FranchiseBillPurchaseOrderFlag)

select TYPE_CES, SystemStartDate, RECEIVERNO, quoteuser, PO, POREGID, item, VENDOR, RECEIVED, WHSE, InvNum, InvDate, FranchiseId, MainSt, Frequency, InvoiceStartDate, InvoiceEndDate, WarehouseOpenDate, WarehouseCloseDate, FranchiseBillPurchaseOrderFlag
from PO_TO_PROCESS_CES_1_11_cicle1

BUT THE SYSTEM SHOWS ME THE FOLLOWING MESSAGE
Msg 544, Level 16, State 1, Line 1
Cannot insert explicit value for identity column in table 'PO_expectedResult_CES' when IDENTITY_INSERT is set to OFF.


CAN ANYBODY HELP ME PLEASE?

prior to your insert you need to do :

SET IDENTITY_INSERT PO_expectedResult_CES ON

insert into PO_expectedResult_CES (TYPE_CES, SystemStartDate, RECEIVERNO, quoteuser, PO, POREGID, item, VENDOR, RECEIVED, WHSE, InvNum, InvDate, FranchiseId, MainSt, Frequency, InvoiceStartDate, InvoiceEndDate, WarehouseOpenDate, WarehouseCloseDate, FranchiseBillPurchaseOrderFlag)

select TYPE_CES, SystemStartDate, RECEIVERNO, quoteuser, PO, POREGID, item, VENDOR, RECEIVED, WHSE, InvNum, InvDate, FranchiseId, MainSt, Frequency, InvoiceStartDate, InvoiceEndDate, WarehouseOpenDate, WarehouseCloseDate, FranchiseBillPurchaseOrderFlag
from PO_TO_PROCESS_CES_1_11_cicle1

SET IDENTITY_INSERT PO_expectedResult_CES OFF

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Another option which you can try is this...

"Exclude the identity column of the table 'PO_expectedResult_CES' while preparing the insert statement"

Caution: In this case identity column will have system generated value.


Cheers,
Pooja Falor