eenlow

Marco, Thanks for the response. I am actually stuck with writing the SP. This is what i have so for and need to include the other DBs... This gives me the 1 company. But im not sure how to write the rest. USE [MSI] GO GO /****** Object: StoredProcedure [dbo].[Gadget_MSI_CASH] Script Date: 06/06/2007 10:46:34 ******/ SET ANSI_NULLS ON ANSI_NULLS ONGO SET QUOTED_IDENTIFIER ON QUOTED_IDENTIFIER ONGO CREATE PROCEDURE [dbo].[Gadget_MSI_CASH] PROCEDURE [dbo].[Gadget_MSI_CASH]AS SELECT CM00500.CHEKBKID, CM00500.DSCRIPTN, CM00500.INACTIVE, CM00500.CURRBLNC, CM00500.BANKID, CM00500.Last_Reconciled_Balance, CM00500.Last_Reconciled_Date, SY04100.BANKNAME, SY04100.CITY, SY04100.STATE CM00500.CHEKBKID, CM00500.DSCRIPTN, CM00500.INACTIVE, CM00500.CURRBLNC, CM00500.BANKID, CM00500.Last_Reconciled_Balance, CM00500.Last_Reconciled_Date, SY04100.BANKNAME, SY04100.CITY, SY04100.STATE .Last_Reconciled_Date, SY04100.BANKNAME, SY04100.CITY, SY04100.STATEFROM CM00500 INNER JOIN CM00500 INNER JOINSY04100 ON CM00500.BANKID = SY04100.BANKID ON CM00500.BANKID = SY04100.BANKIDWHERE (CM00500.INACTIVE = 0) and NOT CHEKBKID = 'PNC CREDIT LINE' (CM00500.INACTIVE = 0) and NOT CHEKBKID = 'PNC CREDIT LINE'

I am trying to create a Cash meter for my company. In my company we have 4 Great Plains DBs. I want to total a field from each database. At this pont i have created a stored procedure for one company get the sum i need. Now my problem is getting the other companies to total with this one. My real problem is im not a pro with SQL nor PowerShell. If possible could someone give me a hand in accomplishing this goal. Thanks Eric