SELECT @ACCSERVER = ACCOUNTSERVER, @ACCDB = ACCOUNTDB FROM PRADNYA.DBO.MULTICOMPANY WHERE EXCHANGE = 'NSE' AND SEGMENT = 'CAPITAL' AND PRIMARYSERVER = 1 SET @REPORT_FORMULA = '-VDTBAL, -EDTBAL, FDT_RECEIPT, FDT_PAYMENTS' SET @@DATA_ADB = '' SELECT @@DATA_SRV = SHARESERVER, @@DATA_SDB = SHAREDB, @@DATA_ADB = ACCOUNTDB, @EXCHANGE = EXCHANGE, @SEGMENT = SEGMENT FROM PRADNYA.DBO.MULTICOMPANY WHERE EXCHANGE = 'BSE' AND SEGMENT = 'CAPITAL' AND PRIMARYSERVER = 1 AND NOT (ACCOUNTSERVER = @ACCSERVER AND ACCOUNTDB = @ACCDB) IF ISNULL(@@DATA_ADB, '') <> '' BEGIN SET @@SQL = "DELETE FROM " + @@DATA_SRV + "." + @@DATA_ADB + ".DBO.FORMULA_CLIENT_MASTER WHERE SESSION_ID = '" + @SESSIONID + "'" SET @@SQL = @@SQL + " INSERT INTO " + @@DATA_SRV + "." + @@DATA_ADB + ".DBO.FORMULA_CLIENT_MASTER " SET @@SQL = @@SQL + " SELECT CLTCODE, PARTY_NAME, 'PARTY', '', '" + @SESSIONID + "', GETDATE() FROM FORMULA_CLIENT_MASTER WHERE SESSION_ID = '" + @SESSIONID + "'" SET @@SQL = @@SQL + " INSERT INTO #LEDGER_DETAILS " SET @@SQL = @@SQL + " EXEC " + @@DATA_SRV + "." + @@DATA_ADB + ".DBO.GET_LEDGER_AUDIT_DATA " SET @@SQL = @@SQL + "'" + @REPORT_DATE + "', " SET @@SQL = @@SQL + "'" + @SESSIONID + "', " SET @@SQL = @@SQL + "'', " SET @@SQL = @@SQL + "'" + @REPORT_FORMULA + "', " SET @@SQL = @@SQL + "'" + @EXCHANGE + "'," SET @@SQL = @@SQL + "'" + @SEGMENT + "'"
Print @@SQL
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)