[thelist] "Smart Tags"

Darren Neimke darrenn at qldstate.com.au
Wed Jun 13 23:08:40 CDT 2001


	> IE 6 may insert links to MSN sites and other sites into your
web pages.

Here's some feedback from another list that I'm involved in:

<snip>
I think there will be a number of ways to use this technology to our
benefit and limit the links list attached to the tags.  Who out there
ever gets the results they want on a search engine in the first page?
If the links list was based on third party results such as that, no one
will use it.  I am sure that they will be configurable.
</snip>



<TIP TYPE="sql" product="SQL7">

To include all records that are ranked equally within a resultset when
using the TOP clause also include the WITH TIES clause.

As an example the 1st statement could actually return more than 10
results, whereas the 2nd will always be abbreviated to first* 10
results.

SELECT TOP 10 WITH TIES 
	asr.application_id AS ApplicationID, 
	COUNT(asr.application_id) AS CountOfApplicationID
FROM Application_security_rel AS asr
GROUP BY asr.application_id
ORDER BY 2 DESC

SELECT TOP 10
	asr.application_id AS ApplicationID, 
	COUNT(asr.application_id) AS CountOfApplicationID
FROM Application_security_rel AS asr
GROUP BY asr.application_id
ORDER BY 2 DESC

</TIP>





More information about the thelist mailing list