i have a #table as follows

CREATE TABLE #ReportingNumbe rs
(
HeadID INT,
EntityID INT,
Type VARCHAR(10),
Value DECIMAL(30,12)
)
a master table as follows

CREATE TABLE HeadIDFieldMapp ing
(
HeadID INT,
FieldName VARCHAR(100)
)

and one transaction table (vData) which have columns as all rows of...