Search Updates - Aug 6, 2013

Question

Post reply

Search Updates - Aug 6, 2013

Steve Jones - SSC Editor

SSC Guru

Points: 734434
More actions
August 6, 2013 at 10:46 am

#297374

minor updates.
there are two sort options, and we are including the publication date along with the author (where appropriate) on the search page.
Comments appreciated.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

very very useful for me, indeed. great job.

I might remember a post i saw two weeks ago,and want to find it;

now with the Relevant First, it's muche easier to page through and find it;

before i'd end up using google site search instead of the built in search for that situation.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 2

I have so been wanting an author search function. Not sure how much use I'll get out of publication date, but if it allows adding start & end dates, I'll love it.

Will go check out functionality now.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Sean Lange SSC Guru Points: 286573 More actions · Answer 3

That is excellent!!! I know that I was at least one of the people who has requested including the author. That in combination with release date and sorting makes the search feature no longer user hostile. Kudos and thanks Steve.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Steve Jones - SSC Editor SSC Guru Points: 734434 More actions · Answer 4

Author is still on the list. I'm hoping to get more changes made here once I get more development resources.

Brandie Tarvin SSC Guru Points: 172994 More actions · Answer 5

Yeah, what I thought you meant was not what I saw. But I do like that the date and name are listed on the results.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.