Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

A google like search Expand / Collapse
Author
Message
Posted Wednesday, February 1, 2012 11:36 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 2,699, Visits: 931
Comments posted to this topic are about the item A google like search
Post #1245475
Posted Friday, February 3, 2012 3:35 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 2,699, Visits: 931
The script was submited do SSC a few weeks before it was published.

In the mean time I managed to implement it in a real world application and the results are good.

Maintaining the tags and registers tables proved to be a challenge as well.
The final version comes with options to
server-side paging (essential for web applications),
more filters, aggregations and order by options.

Thanks for everyone giving it a good rating.
And if you disagree or there any insights be welcome to post your feedback.
Post #1246334
Posted Sunday, July 14, 2013 3:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 14, 2013 3:53 AM
Points: 1, Visits: 1
this script is full of errors... nothing works
Post #1473354
Posted Tuesday, October 15, 2013 1:38 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 2,699, Visits: 931
I just realized I forgot to include my Split function.
Its just a function to split a string, just like in javascript or another language.

So I managed to put it to work in SQL Fiddle (without the performance test, for obvious reasons)

http://sqlfiddle.com/#!6/908d3/1

Just a little rant:
if you cannot put it to work, you re not even trying
Post #1504948
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse