I have not read the entire thread and I am certainly 'Johnny Come Lately' on this one.  When I read the reply about iterating through the data to be inserted...

I would need to test this in order to verify (not sure if it would work).

Perhaps having a timestamp on the table? When a SELECT is initiated this would change....

What exactly are you trying to accomplish? Perhaps rather than telling how to do a specific thing (That may or may not be possible) you could detail what you need...

A good read, and I agree with some things, such as CAPS to define word breaks. What I don't agree with; and seems as if I am not alone here,...

Well you already said it 'Eggs in one basket'. Additionally you have the performance concerns associated with using a single BUS. What kind of drive controller are you using? Is...

Sorry, yes it is.

I should have typed FASTFIRSTROW

Interesting question actually. I never considered this.

When you say converting the data you are speaking of something like a cast, or convert; correct?

I have had  cases, many times when I...

Read a couple replies here and they are all on the right track. You are a novice in SQL code so I will give you a REALLY simple solution. If...

Hmmm... Interesting. Another idea on this is to have a job that would look at the lookup tables and update the individual databases with new records. I COULD even...

AGREED!

I am pretty big on naming. I agree that any naming convention works, just stick with it!  I do like to see naming conventions that at least employ some logic...

I share you opinion with regards to under score. They have no real use and they are hard to type, to me even more difficut to read and look messy.

Regarding...

I myself use a standardized naming convention as well (standard for me).

In all cases I really avoid complex keystrokes (ie:  _) I don't believe that you need _'s all over...

Thank you for your reply. Yes I have considered the option of having these in each database.

In cases where the client can edit / add to the list I have...

Andy,

Good article. A comment that I strongly disagree with is:

'but a damn good starting point is to just add a identity column called rowid and make it the primary...

Yes that is correct. I actually implemented a variation of this late yesterday and it is working very nicely.  Thank you for your assistance. Now that I see it the...