I replied to this thread but it seems to have been lost. So I'll do it again.

No. I will ALWAYS have one address per row. However, if I had...

Is there a good resource to understand DTS packages?

Worked like a charm. Thanks.

Nothing. I was just trying to understand "nuances" of sql server. I have tried this on DB/2 and have been successful in past. I guess it must be the syntax....

I tried that but it didn't like it. I don't have the error with me right now but I'll post the error I got.

I have

INSERT tbl2

SELECT id,fname,lname from tbl1

WHERE ref# = '123'

This works fine but what if I just wanted to insert fname and leave lname out (which would insert NULLS...

Great. I'll be looking for that. Also, could you recommend a good "cook book" for stored procedures for sql server? Is there any book out there that takes a business...

Sounds like creating a "domain field" is not a standard practice in SQL.

Is there any resource which shows standard practices such as naming convention suggestions for files, fields, stored...

The other "standard" that I like to keep (as far as possible) is to have non-intelligent, surrogate value for keys.

For example, I would design the Address Type table as...

When designing State Code table, I am always a bit torn between two designs.

Here they are:

Design 1:

StateID int (pk)

StateCode varchar

StateName varchar

Design 2:

StateCode varchar (pk)

StateName varchar

The advantage...

That is exactly what I wanted to ask. Thanks.

thanks henk

This is a table which refers to two tables menus and roles. so menuid and roleid are pks and fks both. how would you recommend i design a join table?

One of the main things I am looking forward to is the ability to create SPs in languages that you are comfortable with. For example, I am comfortable with VB...

How would I know which index is being used for a statement. Even if I want to SQL Server to decide which one to use, is there any way for...