Steve you guys do a great job and when you need a lift just pull your stats and gloat over the number of people who visit the site. Hard numbers...

If the values in both columns are the same (and correct) we do not need to do anything to the data. Just change the query that is reporting the incorrect data. If...

If both columns contain the same data how will updating col2 help? I think we started the race before the starting gun was...

I was refering to the fact that Dave said that the payroll information was double. Does this mean that the data in both columns contain incorrect information (col1 is 2...

what results do you get when you

select ((col1 + col2)/2) as rightInfo

from table1

where info = wrongInfo

(BTW this does not change any values)

If col1 and col2 contain the same info...

I think it means you have a bad DB design. But not a problem just start writing code while someone finds out what...

I agree with you up to a point. But I would like to suggest that a persons time is a very limited resource. You can use your time helping those...

Better a horse than an a$$

Not having been raised on a farm I have a lot of trouble telling the difference

bkelly, you are a better man than I offering to help Sufain if it appears he really needs help. Bad behaviors should not be acknowledged or rewarded. While it is...

I will agree with the others, as I do not think this is a good idea as it could hurt someone’s feelings. Another thought is that if someone bailed me...

You and Rett Butler.

Mike

As usual I was walking around with my eyes wide shut. I think I will write the word Lollypop on my forehead. This will reduce...

Remi moo is what a cow does.   Moot means deprived of practical significance : made abstract or purely academic.  

HTH

Mike

Well I know Lenny TheLegBreaker (he changed his name to save a few $ on yellow page advertising check...

A vacation only takes place when you leave home. Otherwise you still have to put in the dog and let out the cat, cut the grass and since you are...