Personally I hate NULL and all the hassles it causes.

I was bummed when I saw it was a joke LOL

I definitely come up with the best solution by thinking about it when stumped. If I try to just play around with code to find a solution, it will usually...

Ah ha! It was that cookie setting.

Thanks!

It remembered this morning's login just now, but if I close the browser then the session is lost.

I deleted cookies on the trouble sites and that didn't fix the issue....

I worked for 10 years at GM's insurance company that administered their extended service contracts as well as handled many warranty issues. I can say that most larger companies who...

Nevermind, found my answer!

I needed to use:

COALESCE(SELECT SUM(r.received_count) FROM product_vendor_receiving AS r WHERE r.order_detail_id = d.id), 0)

Which I apparently hadn't tried yet...

Yeah we had a trial version of sql server 2005 that we had to call microsoft to get it extended until we got our new server and a real license...

That helped get me on the right track, got it all running fine now thanks! 🙂

By 'bad data' I mean data that is not in the correct format. For instance, in the above line item import, I ran across 3 rows which had '.5' for...

Thanks! That definitly sheds some light on how to avoid a cursor.

I tried to do an INNER JOIN in my cursor but unfortunalty some of the input data rows have...

Sounds like that one row might have a different number of tags than the other?

Watch out for Outlook 2007 as it now uses the Word html engine instead...

OK, here is the cursor I am using for the above example. This is the simplest cursor I have used so far so it is probably the easiest to work...

For all of the cursors I have written for this data conversion, I need to do one or more seperate selects or inserts besides the row I'm working with. Sometimes...