[Sums from multiple databases...]

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 ON

GO

SET QUOTED_IDENTIFIER ON

QUOTED_IDENTIFIER ON

GO

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.STATE

FROM CM00500 INNER JOIN

CM00500 INNER JOIN

SY04100 ON CM00500.BANKID = SY04100.BANKID

ON CM00500.BANKID = SY04100.BANKID

WHERE (CM00500.INACTIVE = 0) and NOT CHEKBKID = 'PNC CREDIT LINE' 

(CM00500.INACTIVE = 0) and NOT CHEKBKID = 'PNC CREDIT LINE' 

[Sums from multiple databases...]

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