gerez.blogg.se

I started with this company in August of 2011. I was assigend to rework the Sales Import process that I am currently working with in FileMaker Pr Advanced 11 using SQL Server 2005/2008R2 for right now. They replicate the tables that I need to use at 4:30 am every morning, which for now we are housing this replcated data in SQL Server 2005.

We are essentialy forced by iQMetrix to move from FMP to SQL Server 2008. To FatherJack: My company is migrating from FMP to SQL 2008 R2. I am wanting to run the whole query and get one result set. When I run all of this, I get (in this case) 5 diffrent result sets. Thanks for the reply SacredJewel and FatherJack! To Sacredjewel, I just want the combined results of the select statement. I have only been a DBA for almost 6 months, so bear with me. I would use a join, but it would be impossible to use a join for 19 tables. SELECT * FROM iQclerk_SaleInvoicesAndPayments WHERE iQclerk_SaleInvoicesAndPayments.SaleInvoiceID >= Note: These tables are created by another company and I do not know the exact relationships between the tables. next:354353 prev:353949 SELECT * FROM iQmetrix_Customer_Information WHERE iQmetrix_Customer_Information.Id_Number >= -5. SELECT * FROM iQclerk_CashOuts WHERE iQclerk_CashOuts.CashOutID >= -4. SELECT * FROM iQclerk_SaleInvoices WHERE iQclerk_SaleInvoices.SaleInvoiceID >= -3. SELECT * FROM iQclerk_SaleInvoicesAndProducts WHERE iQclerk_SaleInvoicesAndProducts.SaleInvoiceID >= - 1 -2. I would like for all of these tables to be created as one result set instead of 5 (with this example) Here is the code that I have so far: Declare int Declare int Declare int Declare int Declare int Set = (select max(saleinvoiceid) from iQclerk_SaleInvoicesAndProducts) Set = (select max(saleinvoiceid) from iQclerk_SaleInvoices) Set = (select max(cashoutid) from iQclerk_CashOuts) Set = (select max(id_number) from iqmetrix_customer_information) Set = (select max(saleinvoiceid) from iQclerk_SaleInvoicesAndPayments) -1.

I will initially need 19 tables, but for simplicity's sake I will try to use 5 tables for this example. I am wondering if it is possible to combine multiple tables into one table.