Thanks. Yes it would be done to populate look up tables and the project are part of the an integration solution. The source was just part of an...

Thank you, i know it would be simple but wanted to get solution other than using cursor.

Cheers.

Below are my tables, source table would be the source of all information that will get breakdown into 4 different tables as Name table, company, F1 and F2 tables. ...

I have simplified the procedure just to show 1 scenario, but on the real world, the source has a lot of data that needs to go to different table. ...

Here's my code:

--

-- first procedure

--

CREATE PROCEDURE sp_IU_NamesTbl

(

@Age[int] = NULL,

@Name[varchar](30) = NULL

)

AS

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

DECLARE @RowId int=0;

BEGIN TRY

SELECT

@RowId...