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
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..
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.