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 Dotfile 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 www.redgate.com 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
http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx Madhivanan Failing to plan is Planning to fail
]]>