Freetext ………..Rank by | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Freetext ………..Rank by

Anyone can help me…I use sql server. I have two table. I want to find the closest match and also the relevance ranking. How can I do that …..please help… The first table name Dot
file name contain
contain > plan > one
help > twelve > set
Dance > hat > result
electric > arts The second table name sp
file name col001
Dance > one > result
Computer > first
dot > span > code

Go to and download the SQL Compare tool trial version, which allows you to compare objects between same or different databases or different servers. I am thinking thats what you wanted to do comparing two tables.
Refet this also Madhivanan Failing to plan is Planning to fail