it was solved with

DECLARE

@TypeCode varchar(25),

@BomDateB varchar(25),

@BomDateA varchar(25),

@TbName varchar(25),

@sql nvarchar(max)

SET @TypeCode...