How to Update field updatedStuffDiff when i have different values for parts exis

Question

Post reply

How to Update field updatedStuffDiff when i have different values for parts exis

ahmed_elbarbary.2010

Hall of Fame

Points: 3118

March 1, 2021 at 10:49 pm

#3851938

I work on sql server 2012 I face issue I can't update column name updatedStuffDiff

with different feature value for every feature based on partid

so when i have two part have same feature but different values

then display it as result on column updatedStuffDiff

based on partidc and partidx on table #temp

so result i needed is featurename(partidc feature value - partidx featurevalue)

and if no value for feature value for partidc or partidx

then featurename(partidc feature value - NULL) OR (NULL- partidx featurevalue)

SO first i will get partidc and partidx from table temp

then get values related to it from #Featuresvalue and compare to it

and then update result to column updatedStuffDiff

create table #temp
 (
 PartIdc int,
 PartIdx int
 )
 insert into #temp(PartIdc,PartIdx)
 values
 (555,1010),
 (591,888)
 create table #Featuresvalue
 (
 PartId int,
 FeatureName nvarchar(50),
 FeatureValue  nvarchar(50),
 updatedStuffDiff nvarchar(500)
 )
 insert into #Featuresvalue(PartId,FeatureName,FeatureValue)
 values
 (555,'Temperature','5c'),
 (555,'resistance','10c'),
 (1010,'Temperature','20c'),
 (1010,'resistance','30c'),
 (1010,'cold','40c'),
 (1010,'air','7c'),
    
 (888,'Temperature','51c'),
 (888,'resistance','15c'),
 (591,'Temperature','25c'),
 (591,'resistance','40c'),
 (591,'cold','70c'),
 (591,'air','8c'),
 (591,'stress','17c'),
 (591,'pressure','70c')

Expected Result

when update column updatedStuffDiff i will have result two rows :

 Temperature(5c-20c)resistance(10c-30c)cold(NULL-40c) air(NULL-7c)
 Temperature(25c-51c)resistance(40c-15c)cold(70c-NULL) air(8c-NULL)stress(17C-NULL)pressure(70c-NULL)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

jschmidt 17654 SSCommitted Points: 1610 More actions · Answer 2

For the update:

Temperature(5c-20c)resistance(10c-30c)cold(NULL-40c) air(NULL-7c)

Should this be updated in the updatedStuffDiff column of every records in the #Featuresvalue table with PartId=555?

In my head, I'm seeing some sort of full outer join of the #Featuresvalue to itself, maybe preliminary joins to the #temp to get the Idc and Idx sides of the update text.