Hi
I need to pull remote data to local server(In Premises) for
Analyzing report for Management Dashboard
I have used Merge command in Stored Procedure, it works fine in same
instance or same network SQL Server. we have remote server credential.
It is also our server.
But how to pull data from remote server.
Pls advice me
Thank you...
Maideen
What I have tried:
It is my Stored Procedure
MERGE [dbo].[tbl_Finance] AS TARGET
USING edgeadv.[dbo].[MOHead] AS SOURCE
ON (TARGET.DocNo = SOURCE.DocNo)
WHEN MATCHED AND
TARGET.DOCNO <> SOURCE.DOCNO OR TARGET.DOCDATE <> SOURCE.DOCDATE OR
TARGET.CATEGORY <> SOURCE.CATEGORY OR TARGET.TYPE <> SOURCE.MOTYPE OR
TARGET.SUBTOTAL <> SOURCE.SUBTOTAL OR TARGET.GSTP<> SOURCE.GST OR
TARGET.GSTR <> SOURCE.GSTAMT OR TARGET.GROSS <> SOURCE.TOTALGROSS OR
TARGET.NETTTOTAL <> SOURCE.NETTTOTAL OR TARGET.TAX <> SOURCE.GSTAMT
THEN
UPDATE
SET
TARGET.DOCNO = SOURCE.DOCNO , TARGET.DOCDATE = SOURCE.DOCDATE ,
TARGET.CATEGORY = SOURCE.CATEGORY , TARGET.TYPE = SOURCE.MOTYPE ,
TARGET.SUBTOTAL = SOURCE.SUBTOTAL , TARGET.GSTP = SOURCE.GST ,
TARGET.GSTR = SOURCE.GSTAMT, TARGET.GROSS = SOURCE.TOTALGROSS ,
TARGET.NETTTOTAL = SOURCE.NETTTOTAL, TARGET.TAX = SOURCE.GSTAMT
WHEN NOT MATCHED BY TARGET THEN
INSERT
(DocNo, DocDate, Category, Type, SubTotal, GSTP, GSTR, Gross, Tax, NettTotal)
VALUES
(SOURCE.DocNo, SOURCE.DocDate, SOURCE.Category, SOURCE.MOType, SOURCE.SubTotal,
SOURCE.GST, SOURCE.GSTAMT, SOURCE.TOTALGross, SOURCE.GSTAMT, SOURCE.NettTotal )
;