How do IThe INSERT statement conflicted with the FOREIGN KEY constraint "FK_End_Batch_Table_Tbl_Str_Batch". The conflict occurred in database "PIDB", table "dbo.Tbl_Str_Batch", column 'Batch_Id'....

This error signals that you are trying to insert data in your 2nd table for a Foreign Key (FK) that does not exit yet in the first table as Primary Key (PK), in other world there not exists a record in first table with PK equal with the FK that you want to add.

So first you should insert into your first table for that PK and then to insert in your 2nd table all rows that refer that PK as FK.

This error occurs when P_Id is not there and in referenced table you are trying to insert example

TABLE A: Student Table

S_Id(autogen Id) S_Name

1 leela
2 Sam
3 Mike

TABLE B: Student Record Table


S_RID(autogen Id) S_Id(FK) Subject

1 1 Maths
2 3 Science
4 4 GK -- this column we can't able to insert because S_Id 4 is not there in Parent Table

Hope its clear