ahmed elbarbary

ahmed elbarbary

  • NA
  • 1.6k
  • 278.5k

How to separate values by stick when Feature values for C and X is dif

Sep 29 2020 8:56 PM
I work on SQL server 2012 I face issue : I can't get all different value Feature one one row result
 
separated by sticky if it multiple difference
if one different then no need stick.
where c have value and x have value but both not equal each other
so How can i do that Please ?
  1. insert into #replace(PartIdc,PartIdx)  
  2. values  
  3. (1211,1300),  
  4. (2000,2200),  
  5. (3000,3100),  
  6. (4150,4200)  
  7.   
  8. create table #FeatureNameandValues  
  9. (  
  10. PartId int,  
  11. FeatueName nvarchar(20),  
  12. FeaatureValue int  
  13. )  
  14. insert into #FeatureNameandValues(PartId,FeatueName,FeaatureValue)  
  15. values  
  16. (1211,'Weight',5),  
  17. (2000,'Tall',20),  
  18. (3000,'Weight',70),  
  19. (4150,'Tall',190),  
  20. (1211,'Tall',80),  
  21. (1300,'Weight',10),  
  22. (3100,'Size',150),  
  23. (4200,'Tall',130),  
  24. (1300,'Tall',20)
Expected Result :
Tall (80-20) | Weight(5-10) | Tall(190-130)
 
attached file :
 
http://www.mediafire.com/file/mxyr8wr9k98za7o/ExplainReport.xlsx/file

Answers (1)