The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_Reserved_tbl_Identifier_Merchant". The conflict occurred in database "EU_NAS", table "dbo.tbl_Identifier", column 'IID'.

DECLARE @mid bigint, @tid bigint,@lastid bigint

select top 1 @mid=Identifier from tbl_Identifier where StatusID='6' and PoolID='5001'

set @lastid=@mid+5000

select top 1 @tid=Identifier from tbl_Identifier where StatusID='6' and PoolID='5002'


WHILE (@mid <= @lastid)
BEGIN

 insert into tbl_Reserved(M_IID,T_IID) values(@mid,@tid)
    SELECT @tid=@tid+1
 insert into tbl_Reserved(M_IID,T_IID) values(@mid,@tid)
     SELECT @mid = @mid + 1