ahmed elbarbary

ahmed elbarbary

  • 950
  • 1.6k
  • 128.5k

How to get Feature Name and Feature Value separated by $ for table All

Nov 5 2021 12:38 PM

I work on SQL server 2012 I face issue I can't get Feature Name and Feature Value for

Table All Data From table Part Attributes

Feature Name and Feature Value exist on table Part Attributes

I attached Table structure with post

Expected result when make

select * from dbo.AllData

will be

PartID Code CodeTypeID RevisionID ZPLID ConCount FeatureName FeatureValue
413989 32111502 1809942 329888149 4239 1 Type Zener
413989 8541100000 1019997 313023938 4239 1 Product Shape Type Discrete
413989 8541100050 849774 307683692 4239 3 Product Shape Type$Package Family$Type Discrete$SOT$Zener

Attachment: tables_structure.zip

Answers (5)