Load MS SQL Stored Procedure - Out of Range Value Error

Qlik_97 — Tue, 04 Aug 2020 07:44:31 GMT

Hi,

we have to use a stored procedure to laod data from MS SQL DB. In each case where the procedure has to handle a date information, an out of range value occured. All tested procedures are working fine if started from MS Management Studio.

A simple Example: this procedure should deliver the start date to a contract, parameter is the contract number:

SELECT dbo.VTR_GetStartDat('999053143');

The procedure delivered the Out of Range Error for contract 999053143 and a wrong value for contract 23.

It seams the Day and Month Number of the date field are changed during the calculation on DB.

The screenshot shows the date values for this two contracts and the error message which occured for the contract 999053143.

Any advice? Thanks for help in advance.

topic Load MS SQL Stored Procedure - Out of Range Value Error in Connectivity & Data Prep

Load MS SQL Stored Procedure - Out of Range Value Error