Home Forums SQL Server 2005 T-SQL (SS2K5) Inserting data in one table as selecting from other tables RE: Inserting data in one table as selecting from other tables

  • Thanks for the answer.

    Sample data in tables are, as follows

    TABLE RECORDS

    ID book page number

    1 1 1 1

    1 1 1 2

    1 1 1 3

    etc. (I have ten records per each page)

    TABLE NAMES

    ID person_name person_sex priest_name priest_title godfather_name

    1 Lara female priest Alexandar Pesic priest Goran Jevtic

    2 Goran male Dusan Kovac archpriest Milena Taylor

    etc.

    TABLE DATES

    ID birth_date baptism_date

    1 13.07.1950 (in format YYYY., MMMM DD. e.t. 1950., July 13.) 14.11.1952 (in format 1952., November 14.)

    etc.

    TABLE PARENTS

    ID father_first_name father_last_name father_nationality father_faith mother_name mother_birthlast_name...

    1 Goran Pesic Serbian Orthodox Bosa Delic

    etc.

    My Result data should be, as excepted in application:

    TABLE BAPTISM

    ID book page number birth_date baptism_date person_name parent priest godfather

    1 1 1 1 1950., July 13. 1952., November 14. Lara, female Goran Pesic and Bosa b. Delic, Serbian Orthodox...

    I started my app for research over data. The reason for denormalizing is that I received application for printing our data in unique paper form, and that app use only one table, with all the data in it.

    Sincerely yours

    Fr. Ivan Delic

    Serbia