priest Ivan Delic (8/9/2012)

---

Hi all!

I have a simple question. I've made a simple database in Access and upsized it in my SQL Server 2005 Express edition Service Pack 4 on my Windows 7 machine, 2GB RAM.

That database was newbie one, I tried to normalized my data in about 10 tables. In one table called Records I put these columns

ID int NOT NULL PK auto-increment (I don't recall at this moment how is it called actually)

book int NULL

page int NULL

number int NULL

Second table is called names with following structure:

ID int NOT NULL PK auto-increment (see above)

name1 varchar (70)

name2 varchar (120)

Third table is most complex one. Now I realize that I should make it simple. Table name is Parents and the structure is:

ID int NOT NULL PK auto-increment (see above)

father_first_name varchar (50)

father_last_name varchar (50)

father_occupation varchar (50)

...

All those ID fields are the same, e. t. have the same value, so I want to make one table with all those fields together. I know of routine such as

SELECT father_first_name + '' + father_last_name + '' + father occupation AS father,

which is, in my experience with SQL Server, the best solution for putting few fields together in one field.

Could anyone help me with my problem.

P. S. I am aware of possible solution

INSERT INTO...

AS

SELECT

FROM

but I don't know the whole T-SQL sequence.

Sincerely yours,

Fr. Ivan Delic

Serbia