Validating data in a table based on columns configured

-- Create your sample table

create table tbl_Staging  (
    ID int not null primary key,
     Name varchar(100) ,
     Status  varchar(10) ,
     Address1 varchar(100) ,
     Address2 varchar(100) ,
     Address3 varchar(100) ,
     Telephone varchar(20) 
);

create table tbl_Master  (
    ID int not null primary key,
     Name varchar(100) ,
     Status  varchar(10) ,
     Address1 varchar(100) ,
     Address2 varchar(100) ,
     Address3 varchar(100) ,
     Telephone varchar(20) 
);

create table tbl_Validation  (
     FieldName varchar(100) 
);

-- Your Sample Insert Query.

insert into tbl_Staging ( ID,
     Name ,
     Status,
     Address1,
     Address2,
     Address3,
     Telephone) values
    (1, 'XYZ', 'Active', 'asdf', 'xyz' ,'hju' ,'1234')
    
    insert into tbl_Validation (FieldName) values
    ('Name'), 
	('Status'), 
	('Telephone')

--select * from tbl_Staging

--select * from tbl_Validation


DECLARE @fieldName varchar(100)
Declare @Result varchar(100)
Declare @Field_Data varchar(100)
DECLARE @SQLQuery nvarchar(max)
 
DECLARE Validation_Cursor CURSOR -- Declare cursor

LOCAL SCROLL STATIC
 
FOR
 
Select FieldName FROM tbl_Validation
 
OPEN Validation_Cursor -- open the cursor

FETCH NEXT FROM Validation_Cursor
 
   INTO @fieldName
 
   PRINT @fieldName 
   
  

WHILE @@FETCH_STATUS = 0
 
BEGIN
 
SET  @SQLQuery=N'select @Result = ' + @fieldName + ' from tbl_Staging';
 
--EXECUTE sp_executesql @SQLQuery;

EXECUTE sp_executesql @SQLQuery, N'@Result varchar(max) out', @Field_Data out

--select @Field_Data as Validation_result,LEN(@Field_Data) Length_Validation

	IF(@fieldName='Telephone')
		BEGIN
		  IF(LEN(@Field_Data) < 6)
				BEGIN
					Select 'You can not Insert Here'
				END
		   ELSE
				BEGIN
					Select 'Your Insert Query'
				END
		END

   FETCH NEXT FROM Validation_Cursor
 
   INTO @fieldName 
 
   PRINT @fieldName  -- print the name
 
END
 
CLOSE Validation_Cursor 

DEALLOCATE Validation_Cursor