eenlow
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by eenlow
-
-
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
Sums from multiple databases...
in PowerGadgets Discussion
Posted
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'