全动态表格数据处理与转换

CREATE TABLE T_ProductInitialDataTables
( [SerialNo] int NOT NULL IDENTITY (1, 1),
 [ProductEnName] VARCHAR(128) NOT NULL,
 [TableName] varchar(256) NOT NULL,
 [FieldName] varchar(256) NOT NULL,
 [FieleValue] varchar(max) NULL,
 constraint PK_T_ProductInitialDataTables primary key ([SerialNo]))


insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName1','FieleValue11');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName2','FieleValue12');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName3','FieleValue13');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName4','FieleValue14');

insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName1','FieleValue21');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName2','FieleValue22');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName3','FieleValue23');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName4','FieleValue24')


insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])

values('FINANCE','Table1','fieleName1','FieleValue31');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName2','FieleValue32');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName3','FieleValue33');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table1','fieleName4','FieleValue34')

insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('MARKET','Table2','fieleName21','FieleValue21');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('MARKET','Table2','fieleName22','FieleValue22');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('MARKET','Table2','fieleName23','FieleValue23');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('MARKET','Table2','fieleName24','FieleValue24');


insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table3','fieleName31','FieleValue31');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table3','fieleName32','FieleValue32');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table3','fieleName33','FieleValue33');
insert into T_ProductInitialDataTables ([ProductEnName],[TableName],[FieldName],[FieleValue])
values('FINANCE','Table3','fieleName34','FieleValue34')

-------------------------------------------------------------------------------