ethar turky
asked on
Get Related topics based on WordWeight
Dear all,
I have tale NewsSYSNewsTags (NewsSYSNewsTagsID PK, NewsID (fk), NewsSYSTagsID (fk)WordWeight
for given NewsID how can get the most related newsID
thanks
I have tale NewsSYSNewsTags (NewsSYSNewsTagsID PK, NewsID (fk), NewsSYSTagsID (fk)WordWeight
for given NewsID how can get the most related newsID
thanks
ASKER
based on WordWeight as mentioned
what is meant my word weight is it another column in a different table or word weight is some kind of functional requirement.
if it is the later, can you please take an example and explain to us.
if it is the later, can you please take an example and explain to us.
ASKER
Table :
NewsSYSNewsTags (NewsSYSNewsTagsID PK, NewsID (fk), NewsSYSTagsID (fk), WordWeight)
yes its a column in same table its a float field.
NewsSYSNewsTags (NewsSYSNewsTagsID PK, NewsID (fk), NewsSYSTagsID (fk), WordWeight)
yes its a column in same table its a float field.
ok, can you please give us some examples with the data for the table and also the output that you are expecting..
while providing this data, please let us know how this output has come up...
The data can be a dummy data nothing in your real tables.
while providing this data, please let us know how this output has come up...
The data can be a dummy data nothing in your real tables.
Are you looking for NewsIDs with NewsTags having same WordWeight as given NewsID?
If there are multiple NewsTags in the given NewsID, what should be the criteria to pick the other relevant NewsID?
If there are multiple NewsTags in the given NewsID, what should be the criteria to pick the other relevant NewsID?
ASKER
@Harish Varghese, yes this is exactly what I am looking for , sure there are multiple NewsTags in the given NewsID.
The criteria (fmho):
for each NewsSYSTagsID of given NewsID
insert in releated table
select NewsID where WordWeight = +- 5% of (WordWeight of GivenNewsID) and NewsID <> given NewsID
order by WordWeight Desc
thanks
The criteria (fmho):
for each NewsSYSTagsID of given NewsID
insert in releated table
select NewsID where WordWeight = +- 5% of (WordWeight of GivenNewsID) and NewsID <> given NewsID
order by WordWeight Desc
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Define 'most related', preferable with some mockup 'before and after' data.
Where I'm from you could be cousins multiple ways.