I sure hope that this will be a simple solution. I know that I have gotten TONS of help on here before.
Here is my setup. CR 8.5 pulling from SQL2000 using ODBC connection.
My knowledge of SQL is small and my knowledge on CR is basically what I have taught myself from reading through books and on here.
I have approximately 22 different databases on 2 different servers. I need to combine data from a particular table in each database and these tables all have the same structure.
Basically I need to combine the table ASTUXXXX (where XXXX is the year and school number. Such as ASTU4004 or ASTU4006, etc) into basically one large table and then query information from that.
What would the best way be to go about this? Please keep in mind that my knowledge is limited! Thanks in advance for all the help!
Here is my setup. CR 8.5 pulling from SQL2000 using ODBC connection.
My knowledge of SQL is small and my knowledge on CR is basically what I have taught myself from reading through books and on here.
I have approximately 22 different databases on 2 different servers. I need to combine data from a particular table in each database and these tables all have the same structure.
Basically I need to combine the table ASTUXXXX (where XXXX is the year and school number. Such as ASTU4004 or ASTU4006, etc) into basically one large table and then query information from that.
What would the best way be to go about this? Please keep in mind that my knowledge is limited! Thanks in advance for all the help!