Viewing 7 posts - 1 through 7 (of 7 total)
@vj6396, thanks for sharing the code you used.
@celko, there's no need to be rude and dismissive about someone else's design. Some of your comments are universally...
June 21, 2012 at 7:36 am
Sean Lange (12/14/2011)I don't know anything about Rightmove or what the leading UK property companies experience for the typical number of search criteria. I also don't see how that is...
December 14, 2011 at 8:57 am
Sean Lange (12/13/2011)
That solution would require a large amount of dynamic sql with potentially hundreds of joins to the same table.
Sure, my solution isn't necessarily the best by any means....
December 14, 2011 at 8:02 am
Hi again.
It would give you a score if the keywords were not present - the LEFT JOIN means that you get a row returned, and the CASE statement allows you...
December 13, 2011 at 9:45 am
If I've understood you correctly, I think you could go about your problem in the following way. I'm talking at a conceptual level, as it would take too much time...
December 13, 2011 at 8:54 am
@lowell, thanks for the reply.
The SQL Browser service is included in the express edition (at least, it is in the 2008 release). While not technically necessary (esp if...
December 13, 2011 at 8:01 am
Meant to add - also ran xp_readerrorlog and noticed a comment about needing to run RECONFIGURE to apply the Remote Connections setting change (0=>1). Slightly strange, as did that through...
December 13, 2011 at 7:13 am
Viewing 7 posts - 1 through 7 (of 7 total)