Why Join
Become a member
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
C# Corner Home
Technologies
MonthlyLeaders
ASK A QUESTION
Forumguidelines
ahmed elbarbary
1k
1.2k
65k
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 ?
insert
into
#
replace
(PartIdc,PartIdx)
values
(1211,1300),
(2000,2200),
(3000,3100),
(4150,4200)
create
table
#FeatureNameandValues
(
PartId
int
,
FeatueName nvarchar(20),
FeaatureValue
int
)
insert
into
#FeatureNameandValues(PartId,FeatueName,FeaatureValue)
values
(1211,
'Weight'
,5),
(2000,
'Tall'
,20),
(3000,
'Weight'
,70),
(4150,
'Tall'
,190),
(1211,
'Tall'
,80),
(1300,
'Weight'
,10),
(3100,
'Size'
,150),
(4200,
'Tall'
,130),
(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
Reply
Answers (
1
)
varchar declaration in Work_Table
Inst count only approve