python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - variable-declaration

Dynamix SQL Error "Must declare the scalar variable"

I have the @inAdd1-6 and @inAdd declared. The @inAdd1-6 will actually be passed into the Stored Procedure. I will then split them and process the addresses, some as a single address, and others where...
test-img

Dizzy49

sql

variables

dynamic-sql

variable-declaration

Votes: 0

Answers: 1

Latest Answer

You execute your generated statement with EXEC, so you call a new instance which is not aware of any declarations you made in your base script You have to add the declarations to your new script WHILE...
test-img

J.Starkl

Posts

Questions

Blogs

Jobs