:hehe: No, I didn't - but now I am more confused as what entries should I be inserting into these columns

I didn't create primary keys with my inserts into the example tables- assume this is the problem?

Thanks guys. So every row in the User and Categories table will be linked to the UserCategories table? I know I am missing something obvious as they both tables have...

Thanks for your advice. There are a lot of points here, so to be clear. Naming to avoid ambiguity/irrelevant conventions is a must so I'll definitley do this, but have...

Would my assumptions be near to the mark?

Thanks Sean

I hope the follwing info gives more of an idea. Economic Class relates to which sector of the economy the company fits into - (Financials, Cyclical consumer goods, Technology)...

Hi Steve, I am not sure what you mean "What are you going to do when you want to have a SicText5? Or a 4th PreviousName?" How could I design...

Hi, I think I am closer to posing a clearer question. Here is a company information table that I split from the address one:

USE DataCompany

CREATE TABLE CompanyInformation

( CompanyCategory varchar (100)

,CompanyStatus...

Ok, thanks for all your points- I will separate the other information that goes beyond addresses into another table and change the lengths. Then I will see where I am...

the financialservices is names, they will all be set up the same but obviously the names will be different. I will rethink it and get back to you...

Create Table for CompanyAddress1

USE MasterAddress

Create Table CompanyAddress1

(

ID int IDENTITY(1,1) PRIMARY KEY

,CompanyName varchar (MAX)

,CompanyNumber varchar (MAX)

...

OK, the names table was a generic way of listing for brevity, the tables are different industry sectors. Yes all of those tables are exactly the same. will your solution...

Did you mean from information schema columns?

1IDintNULLNO

2databasenamevarchar50NO

3sectorvarchar75YES

4datedateNULLYES

5influenceclassificationvarchar50YES

6firstnamevarchar50NO

7lastnamevarchar75NO

8companyvarchar100NO

9phonevarchar50NO

10companyrevenuevarchar100YES

11companysizevarchar100YES

12titlevarchar-1YES

13linkedinIDvarchar-1YES

14emailvarchar-1YES

Judging by the zero replies this isn't possible. So could someone tell me whether it would be more logical to merge the tables and just have a flat table...