IF OBJECT_ID('TempDB..#Field','U') IS NOT NULL
DROP TABLE #Field
CREATE TABLE #Field
(
fieldID int NOT NULL,
pkFromOrigTable int NOT NULL,
fieldName varchar(200) not null,
fieldValue decimal(30,20)
)
Any advice, suggestions are more than welcome. I want to try and avoid creating something as bad.
My apologies...based on your sample code above it appears like you already want to convert those float values to decimal. A timestamp field could also be helpful depending on how the table will be used. This is of course if it isn't arleady being captured in another table.