one option might be if you really want it in SQL is import all the data to MYSQL then move it to SQL.

Not for sure if this will work for...

I am not any help, but i sure hope you find a good answer because I am going to be in your shoes in about 3 to 4 months with...

Thanks Jim i will take a look. Yeah i had not even heard about it until the vendor said it was based in sybase. They say it's getting ported to...

SQL anywhere 8

basically i want to learn about it to keep the vendor honest. I don't like just having to wait for them to troubleshoot something and take 4 hours...

yeah that might work as well.

one hell of a last two days, 15 hr day yesterday and then a major fiber cut and a telco failure today good times.

yep that is the problem, snumber is the primary key. Pretty much my only option if i need to keep the DB intact is drop the keys make my chnage...

i thought about that, dropping the keys, i will make sure i use a transaction the error catching looks very handy.

thanks for the tip on that.

Well some what clear the only problem i see with this is the data in the PK is what needs corrected and the table that it is in does not...

sorry, i work well with pseudo code. lets take data types out of the picture or assume all datatypes to be the same.

here is the overall story snumber is...

GSquared (6/7/2011)

---

Definitely sounds like more fun than I usually allow myself to experience. 😛

If you aren't familiar with Between, are you familiar with using "In" in Where clauses, to filter...

sweet i didn't know about the BETWEEN.

this actually got what i wanted for this piece. Ok to lay this all out for the big picture. I am working on...

BoL has been downloaded thanks for that.

true and i am sure i will be searching the forum in the future as i run into new SQL and SQL server problems.

thanks guys for the quick response, i tried that before, but when i tried it i was doing my joins out of order. silly mistake.

also as a side note...