BI Connect to SQL Store Procedure

Cheryl Ansah 1 Reputation point
2021-02-07T02:07:09.423+00:00

Hi I am trying to run this script , what ever I do I get this error.

USE [GTLS_JaixMain]

DECLARE @return _value int

EXEC @return _value = [dbo].[ConsignmentReportAll]

SELECT 'Return Value' = @return _value

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,666 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.