[sqr-users] sqr problem - generic begin-select

[Jay Sagadraca <knight7883@yahoo.ca>]

 Hello,
 
        Here is my problem:
 
        1. I have a flat file that I bcp in to a table.  Let's say the columns 
in the tmp_table are :
        - Last Name
        - First Name
        - Address 1
        - Address 2
        - City
        - State/Provincial Code
        - Country Code
        - Postal Code
        - Box_1
        - Box_2
        - Box_3
 
        2. After a few months, I have another flat file that is
 almost similar to the above except the boxes are now the following :
        - Box_1
        - Box_3
        - Box_4
   
        3. Now, I have the following which was derived from #1 :
 
        begin-select
        Last_Name
        First_Name
        Address_1
        Address_2
        City
        State_Prov_Code
        Country_Code
        Postal_Code
        Box_1
        Box_2
        Box_3
        from    tmp_table
        end-select

        4. Now my question is, is there a command in sqr wherein you
 can do the following to have a generic begin-select in the sqr inorder that 
you will not be changing the previous sql?
 
        begin-select
        Last_Name
        First_Name
        Address_1
        Address_2
        City
        State_Prov_Code
        Country_Code
        <any column>    *this can be interchangeable
        <any column>
        <any column>
        from    tmp_table
        end-select
 
        Please help me.
 
        Thank You,
 
        Jay Sagadraca




Jay V. Sagadraca

Markham, Ontario, Canada

email : knight7883@yahoo.ca



---------------------------------
Post your free ad now! Yahoo! Canada Personals

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users