i searched the net about sql server full text indexing and ranking and got this sample sql statement and it works using 1 table only:
SELECT myTable1.id, myTable1.Title, fulltextSearch.Rank
FROM myTable1
JOIN
FreeTextTable(myTable1, [myField1], 'awesome ranking') fulltextSearch
ON
myTable1.id =...
hi guys, ive been trying to extract names from email address field.
if i have emails like these:
adam.peter@yah123.com
esther.oliver@test678.com
.
.
.
how to i write a sql to make it to look like this:
adam peter
esther oliver
i been using replace,trim functions but it only gets me so far...
hi guys, i just thought to update you regarding this challenge.
well, i was able to get it to work. what i did was just to have links to ajax.js and ajax-dynamic-list-countries.js only on the header side and put/add the cities.asp code into the countries.asp code. that's it. and it worked.
i...
hi Diancecht,
on the ajax-dynamic-list.html, i changed the function ajax_showOptions to ajax_showOptions2:
.
.
<input type="text" onFocus=clearText(this) name="cities" autocomplete="off" onKeyUp="ajax_showOptions2(this,'getByLetters2',event)">
.
.
and on the ajax-dynamic-list-cities.js, i...
i am trying to adapt this php suggest:
http://www.dhtmlgoodies.com/index.html?whichScript=ajax-dynamic-list
in my code, the suggest for text input countries works. the suggest for text input cities works.
but one would not work if i try to have them both have suggest.
what am i missing? what...
hi guys, AVE is only for columns? can i use this in rows? if i have this sample how can i have the sql server calculate this:
average of rows with null
id col1 col2 col3 col4
1 1 2 3 4
2 null 1 7 7
3 1 null null 9
4 3 2 1 6
to this?
for...
hi guys, ive searched the net and didnt find any lead.
is there a way in sql server for me to know when a particular row was updated without having to add a date/time field on the table?
tnx for any inputs.
thanks to ArizonaGeek and to kjv1611.
and most especially to JimInKS for some sample and anotherhiggins for such a comprehensive explanation.
guys, have a nice weekend!
hi guys, im totally newbie to php. i need to convert a php script to asp and this seems to be not working. can you please have a look to see what's wrong in my asp script?
thanx
the php script:
.
.
if(isset($_GET['getCountriesByLetters']) && isset($_GET['letters'])){
$letters =...
Hi guys, I am experimenting on the SOUNDEX feature of SQL Server 2K and came across with a roadblock.
I have this code and it's not returning a record but I've checked that there's a content in the TEXT data type field called Description the word "alcohol"(without the quotes).
SELECT...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.