Hi Guys and Girls,
In my project I am having Users and Groups (created by them) and there are curresponding tables Users and Groups . I need to do a search of groups. So I need to search with Group Name which is in Groups table and Created User Name which is in Users table. There are three cases for me to check
1. if(UserName !=''AND GroupName!='')
2.if(UserName =='')
3.if(GroupName=='')
I need the results to be sorted according to relevence, so I'm using a FREETEXTTABLE search.
So currently I am planning to implement it by writing a stored procedure with with the above mentioned conditions. Means, there are 3 if-else conditions.
Is there any better way to do this.
Regards
Jophin
...
Go to the complete details ...