Parse xml / match records in sql / insert rows - quick task..

Part 1:

Have a quick task of parse a sitemap xml - has <loc>string</loc> obviously..

Need to insert all rows into sql server (will change connection string when done, you can use local sql express to test)..

You will need to pull down a sitemap file to test..

Add columns for tofetch (bool, default null), fetchedby (varchar(50) default null), lastattempt (Datetime, default null), error (bool, default 0)

Clustered index on id (ident column).

Create an index on loc

Part 2:

Read a row from an existing table

Replace \/ with / (stored wrong in db)

Check your table for matches

If matched set tofetch=0

Create a test table for this and populate with some rows..


C# Project

SQL Create scripts

We will then compile, change the connection string to our sql server, and test then pay.

NOTE: Would like to have this script DONE today so please only bid if you can start immediately.

Taidot: C# -ohjelmointi

Näytä lisää: string match, programming scripts, programming sql, match string, local programming, express scripts, sharp test, test sql server, sql server scripts, sql programming, sql 2012, rows, need xml file programming, loc, bool, rows insert, sql create script, create sharp project, quick task, datetime, script xml file sql, insert sql, match records, set sql server express, match existing

About the Employer:
( 22 reviews ) Washington DC, United States

Projektin tunnus: #1722369

Myönnetty käyttäjälle:


Please check PM

40 $ USD 1 päivässä
(16 arvostelua)

7 freelanceria on tarjonnut keskimäärin 86 $ tähän työhön


Please check PMB. I am sure I will provide solution by my (USA) EOD.

100 $ USD 1 päivässä
(22 arvostelua)

Hi, I can code this for you if you like. Thanks.

100 $ USD 1 päivässä
(13 arvostelua)

kindly check pmb

100 $ USD 0 päivässä
(8 arvostelua)

Please see PMB.

80 $ USD 1 päivässä
(4 arvostelua)

I have lots of hands on experience in .net / SQL server. This project is less than a day's work

100 $ USD 1 päivässä
(0 arvostelua)

Rest Assure, The work will be done by me within you provided timeline.

80 $ USD 1 päivässä
(0 arvostelua)