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ää: parse xml matches, string programming, string match, programming sql, programming scripts, programming in sql, parse programming, match string, local programming, express scripts, c sharp test, c # sharp test, test sql server, sql server scripts, sql programming, Sql 2012, rows, parse, parse and, parse a string, need xml file programming, loc, bool, parse error parse error, parse table

Tietoa työnantajasta:
( 22 arvostelua ) 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)