If you ask a salesperson, they will say the salesperson should make more. If you ask a developer, they will say a developer should make more. The only objective answers...

Kenneth Wymore (12/3/2010)

---

Heather, You may also try Apocalyptica. Some of their songs are instrumental hard rock with cellos. So it moves fast enough to keep you from falling asleep.

I...

"http://www.simplynoise.com/"

Thank you for posting that link! I'm going to try it out soon.

Like many others here, I find music with lyrics to be very distracting. Actually I prefer not to listen to music, but I'm in a cubicle environment and find it...

Just wanted to wrap this thread up...

I couldn't figure out why the code using the cursor worked but the set-based code did not, so I updated each record individually using...

Steve, actually I did try code like you posted first, but it exceeded the maximum number of result sets that could be displayed (100 is the max and my query...

Okay, I tried the cursor approach and interestingly I don't get the overflow error when I use a cursor. I can't figure out why it works with the cursor but...

The biggest number in the decimal field (the field I'm trying to update) is 740.9685, and the biggest number in the other (tinyint) field it gets multiplied by is 10....

Thanks for your replies, Jeff and Steve.

I did start trying to isolate the problem records and so far I've figured out that there's more than one record causing the problem....

I used to use folders to organize my email, but often found that messages would fit into multiple categories and I would have to decide which category was the best...

I bike to work everyday and even though my commute is only 1.5 miles one way, I still feel the benefit of biking if I don't do any other exercise...

Well, you can use it to import tables, but you lose all of your keys, indexes, triggers, etc., so I haven't found it to be very useful. They took away...

Thanks, Jason. The first solution works, but will not work when I don't know the columns ahead of time (I'm trying to avoid having to list each column explicitly). The...

Sorry, you're right - it does work correctly in text mode. Thanks a lot!

Hmm, I still get the same results when I display the results as text (is that what you mean by text mode?).