Em Andamento

Stored Procedure/Function

Hi

Looking for an expert in SQL 2005 to build a stored procedure/function that will do the following.

1) Take data from a table called noisewords and compare it against another table’s column; if that table has any noise words ignore them.

2) Once the noise words have been ignored start looking through the table column for matching words and if they exist update column pagerank by 1000.

Example 1 tblSearchPhrases has 4 columns PageTitle, PageParagraph, BaseURL and PageRank.

PageTitle has: Cheap flights to Washington DC

PageParagraph has: Cheap flights to Washington DC via Heathrow

BaseURL has: [url removed, login to view]

Example 2 PageTitle has: Cheap flights to Heathrow

PageParagraph has: Cheap flights New York

BaseURL has: [url removed, login to view]

'to' is a noise word and will be ignored.

So Example 1 has 'cheap' in pagetitle, pageparagraph, baseurl

has 'flights' in pagetitle, pageparagraph, baseurl

has 'Washington' in pagetitle, pageparagraph, baseurl

has 'dc' in pagetitle, pageparagraph, baseurl

Heathrow is not in the title so is ignored.

So Pagerank will be: 12000

So Example 2 has 'cheap' in pagetitle, pageparagraph, baseurl

has 'flights' in pagetitle, pageparagraph, baseurl

has 'Heathrow' in Title

So Pagerank will be: 7000

Next look for words in title and see if they are within 10 words of each other in PageParagraph ignoring noise words

If yes, update pagerank by 500

For the pagetitle, pageparagraph you can use FullText Search or ‘like’ so long as only hole words are found but will need to use ‘like’ for BaseURL

Habilidades:

Ver mais: stored, function, flights, dc, dc dc, compare exist, function stored procedure, sql stored function, compare update, stored procedure function, function search, compare table data, stored procedure expert, SQL stored, word table expert, 7000, need 7000, 1000 pagerank, sql expert need, hole hole, looking word expert, search flights, sql update, search procedure, 12000

Acerca do Empregador:
( 0 comentários ) Washington, United Kingdom

ID do Projeto: #167583

Premiar a:

oscguy

Hi, i'm MSSQL expert with 7 years experiences. I can do complex stored proc with lot of functions so i can get your job done quickly around 8 hours MAX for both testing and finishing Regards

$200 USD em 1 dia
(37 Avaliações)
3.3

3 freelancers estão ofertando em média $167 para este trabalho

tiabrains

Dear Sir, Let us help you. Regards.

$200 USD in 3 dias
(108 Comentários)
4.6
ashif26

hi its ashif from toqsoft technologies. since 10 years i m in software solution previously we used MSSQL2000 now we are doing development in MSSQL2005, so i ve much experience to finish your work. thanking you www Mais

$150 USD in 2 dias
(0 Comentários)
0.0
SmartGuru

Hi, I will be glad to provide you the stored procedure doing what you want. Kind regards.

$150 USD in 5 dias
(33 Comentários)
0.0