I wonder if anyone has ever done a survey to find out how many of us are left in the business.  By "us" I mean the people who used a...

Atif,

We are on 2005, but, as GSquared points out, an XML design like that would be a violation of 1NF, and I just can not bring myself to design a...

Atif,

That would be a good way to go, but I can not do that one easily because I will also have to do financial reporting on the data and I...

Tim,

Great! How do you guys handle the storage of the NCPDP field data for claims? This is exactly what I am working on.

Stan

Bob,

Thanks for the ideas!

As to more details, I think it would get boring pretty quick. It is about isurance.:-)

Stan

The method that I have used in the past is to pick a single time zone as the time of record and to then keep track of the offset from...

Great stuff folks. Thanks.

BTW to Sue, this is a legacy system that I am working on. I would like to be rid of the problem, but I am...

3 and 4 are development terms in VB.   I am not aware of any context that they apply to SQL directly.

Ok. This sounds like you are using databoumd controls. Not a good thing to do to your poor data. Pull the result back as a recordset and...

I had no trouble understand it and I am just a poor stupid programmer.

Perhaps a personal bad habit, but I just dive in head first. I have never seen anything, regardless of the time spent on specs and prototyping, that didn't end...