How to use a stored procedure from SQL Server in Qliksense?
THIS IS THE FIRST PART OF THE CODE, AFTER IT ARE JUST MANY SELECTS AND JOINS:
USE [database name] GO /****** Object: StoredProcedure [dbo].[IncomeExpenseReport] Script Date: 10/15/2019 10:31:13 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
ALTER PROCEDURE [dbo].[IncomeExpenseReport] @startDate DATETIME, @endDate DATETIME AS BEGIN CREATE TABLE #TmpDocLinesTable( [TotalValueExpense] DECIMAL(28, 6), [TotalValueIncome] DECIMAL(28, 6), [TotalValueIncomeWithVTA] DECIMAL(28, 6), [CostCenterCode] NVARCHAR(4000) COLLATE SQL_Latin1_General_CP1_CI_AS, [CostCenterName] NVARCHAR(4000) COLLATE SQL_Latin1_General_CP1_CI_AS, [CostCenterGroupID] INT, [CostCenterGroupName] NVARCHAR(4000) COLLATE SQL_Latin1_General_CP1_CI_AS, [Difference] DECIMAL(28, 6) ) SET NOCOUNT ON; DECLARE @partnerEntity INT DECLARE @agentEntity INT DECLARE @documentEntity INT DECLARE @costCenterEntity INT DECLARE @idLookupValidDocument INT
---
-it connects to the database and then it says " error around the word 'ALTER' " - or something similar
-I need to execute stored procedures from an SQL Server Database in QlikSense in order to get some data.