I have a table like this...
sno -- int
and table is having 1000 records
what I need to get is I need to compare textbody column with all the remaining 999 rows and find out the matching percentage. And this needs to be done with all 1000 records.
SSIS Fuzzy grouping or fuzzy lookup is not going to work with text type column. I need to write a procedure to find out the percentage.
Please help me out..
thanks in advance..