How to use a stored procedure from SQL Server in Qliksense?

Ted_Baker — Wed, 16 Oct 2019 11:46:21 GMT

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.

Can you please tell me what the problem is?

Cheers!

topic How to use a stored procedure from SQL Server in Qliksense? in Connectivity & Data Prep

How to use a stored procedure from SQL Server in Qliksense?