Extracting data

Last updated:


    This section shows you how to extract data from the information held about a job in the application.

    Extracting data

    In this example, a telephone number is extracted from General > Addresses > Numbers.  Form HR1 requires the telephone number of the company to be provided:


    The following listing shows an example script to extract this information:

    INSERT  INTO @Data
    SELECT  'Employers telephone number', n.Number
    FROM    Admin_Number an 
            INNER JOIN Number n ON an.NumberID = n.NumberID 
            INNER JOIN NumberType nt ON n.NumberTypeID = nt.NumberTypeID
    WHERE   (nt.NumberTypeID = 1) AND (an.AdminID = @AdminID)