Quick question, is it possible to use the SQL TOP syntax in a Full Search Query something like
Select Top 1 title from SCOPE() where = 'All Sites' AND Productid= '1234556'
Can you use nesteed select statments ?
Select title from SCOPE() where = 'All Sites' AND Productid= (select productid from scope() where scope = 'all sites' AND product = 'example')
View Complete Post