Thanks arthurolcot!.

There is a small change in the table structure in which the data needs to get inserted.

CREATE TABLE ID(

NO_PK INT IDENTITY(1,1) PRIMARY KEY,

Id INT

)

CREATE TABLE PROJECT(

NO_PK_Project INT IDENTITY(100,1) PRIMARY KEY,

NO_FK_ID INT REFERENCES ID(NO_PK),

PROJECTID INT,

ID INT,

PROJECTNAME VARCHAR(20)

)

Before inserting into project table I need to know the corresponding ID(NO_PK) and insert the respective rows. Then continue the same. Please suggest.

Thanks

Jim