Database

alter table tA
add constraint tB_tA_FK1 foreign key (b_id)
	 references tB (b_id)

USE [DB_SRC]

CREATE TABLE #corr_id
(
   b_id_src  INT NULL,
   b_id_dst  INT NULL
}

DECLARE @IdNext AS INT
SET @IdNext = IDENT_CURRENT('[DB_DST].dbo.tB')

-- Set the correspondence
INSERT INTO #corr_id (b_id_src, b_id_dst)
	SELECT 	b_id, ROW_NUMBER() OVER (order by b_id) + @IdNext 
		FROM tB WHERE b_id IN .....code depending on user choise

-- Use the correspondence
INSERT INTO [DB_DST].dbo.tA
	SELECT	#corr_id.b_id_src FROM tA INNER JOIN #corr_id ON tA.b_id = #corr_id.b_id_src

USE [DB_DST]
ALTER TABLE tB	ADD id_src INT NULL
GO

USE [DB_SRC]

-- Set the correspondence
INSERT INTO [DB_DST].dbo.tB (id_src)
	SELECT	b_id FROM tB WHERE b_id IN .....code depending on user choise

-- Use the correspondence
INSERT INTO [DB_DST].dbo.tA
	SELECT	tBDST.b_id FROM tA INNER JOIN [DB_DST].dbo.tB AS tBDST 
			ON tA.b_id = tBDST.id_src

USE [DB_DST]
ALTER TABLE tB	DROP COLUMN id_src
GO

alter table tA
add constraint tB_tA_FK1 foreign key (b_id)
	 references tB (b_id)

USE [DB_SRC]

CREATE TABLE #corr_id
(
   b_id_src  INT NULL,
   b_id_dst  INT NULL
}

DECLARE @IdNext AS INT
SET @IdNext = IDENT_CURRENT('[DB_DST].dbo.tB')

-- Set the correspondence
INSERT INTO #corr_id (b_id_src, b_id_dst)
	SELECT 	b_id, ROW_NUMBER() OVER (order by b_id) + @IdNext 
		FROM tB WHERE b_id IN .....code depending on user choise

-- Use the correspondence
INSERT INTO [DB_DST].dbo.tA
	SELECT	#corr_id.b_id_src FROM tA INNER JOIN #corr_id ON tA.b_id = #corr_id.b_id_src

USE [DB_DST]
ALTER TABLE tB	ADD id_src INT NULL
GO

USE [DB_SRC]

-- Set the correspondence
INSERT INTO [DB_DST].dbo.tB (id_src)
	SELECT	b_id FROM tB WHERE b_id IN .....code depending on user choise

-- Use the correspondence
INSERT INTO [DB_DST].dbo.tA
	SELECT	tBDST.b_id FROM tA INNER JOIN [DB_DST].dbo.tB AS tBDST 
			ON tA.b_id = tBDST.id_src

USE [DB_DST]
ALTER TABLE tB	DROP COLUMN id_src
GO

alter table tA
add constraint tB_tA_FK1 foreign key (b_id)
	 references tB (b_id)

CREATE PROC prc_insert_example
AS

SELECT * INTO #TEMP
FROM MYTABLE

CREATE PROC prc_insert_example
AS

CREATE TABLE #My_Temp
(
Age int,
FName varchar(15)
)

insert into  #My_Temp
select Age,FName from MYTABLE

DECLARE @Result VARCHAR(MAX)
DECLARE @Final_Res VARCHAR(MAX)
Set @Result = (SELECT TOP 1 WITH TIES theCol FROM (SELECT * FROM Tbl_Origin WHERE Zip_Final =@Zipcode ) AS t1 UNPIVOT (theValue FOR theCol IN (@Querystr)) AS u1 ORDER BY theValue DESC)

IF @Result IS NULL 

Set @Result = 'Select Top 1 theCol from Tbl_Origin'

else 

select @Result