Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, January 4, 2016 12:17 PM
Points: 2,738, Visits: 969
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: Monday, January 4, 2016 12:17 PM
Points: 2,738, Visits: 969
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: Monday, January 4, 2016 12:17 PM
Points: 2,738, Visits: 969
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
Posted Wednesday, May 11, 2016 7:04 AM
SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:45 AM
Points: 8,328, Visits: 858
Thanks for the script.
Post #1785193
Posted Thursday, October 13, 2016 7:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 30, 2016 4:51 AM
Points: 3, Visits: 23
If you can't upload a script that actually works as intended, maybe you shouldn't upload. Maybe test first, then upload. You even write what part of the script is missing and then you don't even share it. If your intention was to make it a homework assignment then well done, otherwise it's just poor work.
Post #1825646
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse