Recent content by chlorineKid

Yes, I'd agree with that. I always avoid cursors unless there is NO other way to solve the problem. They are extremely slow so they are best avoided. CK

You probably need to use a cursor for what you are trying to do: Look up cursor in BOL and it will explain the syntax, etc. CK

Thanks for your reply, CK

Example data: bad suburb column: Correct suburb file is as below new market Newmarket Sandiriham Sandringham So we've got mispellings, etc. The address columns are in incorrect separate columns. CK

Why not bcp it out of one table, then bcp it in to the other. A bit laborious but it should work. ck

Because the performance on them is often extremely slow. But of course if they are the only way to solve the problem I guess I'll have to live with it CK :-)

Hi all, I'm looking for ideas on how to approach the following: I've got a table in a SQL server database which has a whole lot of person information in it. This table needs to be "cleaned" so that the suburb and city fields are in a very specific format. There is a file with the...

Hi all, I'm looking for ideas on how to approach the following: I've got a table in a SQL server database which has a whole lot of person information in it. This table needs to be "cleaned" so that the suburb and city fields are in a very specific format. There is a file with the...