It turns out that the SQL 2014 version I installed is an Express, and Full-Text Indexing is excluded from Express.

What can I do if I want to search varchar(2000)...

Thank you so much for your quick reply. It is working as amazing miracle.

Here is the screenshot of my email inbox. I was wondering why Lynn would have replied three times. Sorry Lynn.

hmmm, I didn't realize I started three threads, indeed I encountered some hiccup when I posted it - the browser just hangs there - I had to re-submitted it,...

Thank you Erland, I see only one post from Lynn, but I did receive three notification emails about her posts.

Thank you Lynn,

Per your link it says:

match_expression [ NOT ] LIKE pattern [ ESCAPE escape_character ]

In my case I used: where city like '%' + @pattern + '%'

set...

• This reply was modified 4 years, 9 months ago by  PasLe Choix.

Actually I just noticed that post is about PL/SQL and Oracle, not SQL Server. What SQL Server and Oracle call Analytic Functions could be different, as same named functions...

Haha, thank you Phil and please don't get panic on me, happy new year

That post is from 2004, it's almost 16 years old and based on SQL Server 2000... None of the Analytic functions even existed in 2004; most of them...

No it isn't, it's a Window function.

John already provided a link to analytic functions. Had you followed it, you would have seen that...

Thank you Jonathan for the answer, it returns expected result: top 2 for each group, that's what I want.

Thanks John,

DENSE_RANK() is an analytical function

Below is what I tried:

Select *
From Freelancer t
Where t.ID in (
Select top 2 ID
From Freelancer tt
Where tt.fl_name = t.fl_name
Order by tt.bonus desc
)
Order...

Thanks.

Restriction:

No any analytical function should be used in the query and no temp table.

Thank you DesNorton for catching that.

added back. sorry again.