How to carry one's self in public is very tightly tied to place and time. I've worked in Japan for 11 years, Germany for 5, and the U.S. now...

I changed two things, and that seems to have fixed it: 1) I had been referring to the sproc up until today as dbo.xyz...., then this morning just before...

A kludge, but a very clean and clever one! Thanks.

OK, I tried it an see that the answer is not as obvious as I thought (...destroy all floats). But if there isn't a broad brush way to avoid...

Good ole BOL. The answer usually is there, but only when I know what the problem is. Thanks for the explanation -- I will search and destroy all...

Hi Everyone:

The following is my theory of what caused the problem:

The issue seems to have been one field in the Products table that stores the case equivalent value of a...

Hi Everyone: Thanks for the responses. I will post some example code, and what I think solved the problem in an hour or two.... I don't understand...

Our factory runs on a automation program based on sql server 6.5 (!). At a certain point hardware became an issue, so we created virtual machines using vm ware...

Very nice (and unexpected!) to open the newsletter and see a photo of O-sensei! I had done aikido for many many years (ended with a 2-dan), most of it...

Lots of good comments here. I am nearing the end of an MBA, fully paid for by my employer, at a 'non-name' school. I have degrees from two...

Hi all: Thanks for the comments. AS seems to be the way to go -- I agree with the observations re the traps I was falling into. ...

Thanks for the suggestions -- it hadn't occurred to me to use a parameter tracking table like that. It's a useful tool. As regards the logic suggestion, my...

Mea culpa.

I found the other forum after posting to this one.

Hi Loner: I understand what you say... Unfortunately I found that storing the data as you say, and then relying on queries (in this case subqueries) slowed things down...

Sorry I wasn't clear on that. DATEID is a foreign key to the dimDate table, and represents a month/year combo. So, there is a new row for each...