vibrokatana
New Member
A couple of hours before I left work, while updating the gaslines table(a 200k+ rowed table) I noticed a slight problem with our unique keys, it seems they had decided that asexuality was very popular and had MULTIPLIED. turns out that while cleaning up the vector data, it had decided to make every line that was intercected, 2 lines and so on creating a huge mess with 500 or so rows needing to be fixed.
Being resourceful I mad a query that listed the key that was duplicated and listed how many times it was. the problem being that my boss now has to fix it all. She isnt very happy with it, but is glad she doesnt have to go one by one to find them all...
Anyway it would be nice if you all could pray for her to be patient and not to get frustrated with the slow program (its handling ~1.3GB of data), and that the program(autocad) would not crash often.
Being resourceful I mad a query that listed the key that was duplicated and listed how many times it was. the problem being that my boss now has to fix it all. She isnt very happy with it, but is glad she doesnt have to go one by one to find them all...
Anyway it would be nice if you all could pray for her to be patient and not to get frustrated with the slow program (its handling ~1.3GB of data), and that the program(autocad) would not crash often.
