I work on SQL server 2014 I face issue
but I don't know how to solve it
I need to add columns header as first row on table
I Try as below but i get error
Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.
Expected result as below :
PartID Code CodeTypeID RevisionID ZPLID ConCount FeatureName FeatureValue
PartID Code CodeTypeID RevisionID ZPLID ConCount FeatureName FeatureValue
2020 ab5060 877491 26553312 4125 10 Heat IC
What I have tried:
CREATE TABLE #AllData
(
PartID INT,
Code VARCHAR(20),
CodeTypeID INT,
RevisionID BIGINT,
ZPLID INT,
ConCount INT,
FeatureName nvarchar(500),
FeatureValue nvarchar(500)
)
insert into #AllData VALUES(2020,'ab5060',877491,26553312,4125,10,'Heat','IC')
insert into #AllData
SELECT STUFF((
SELECT ',' + CAST(name AS VARCHAR(50))
FROM (
SELECT name
FROM tempdb.sys.columns
WHERE [object_id] = OBJECT_ID(N'tempdb..#AllData')
) k
FOR XML PATH('')
), 1, 1, '')
SELECT * FROM #AllData