Must declare scalar variable error

Question

1.44/5 (2 votes)

See more:

, +

Hi I am getting Must Declare Scalar variable Error

What I have tried:

SQL

DECLARE @Table1 Table (ID INT, Value INT)
INSERT INTO @Table1  VALUES (1,100),(1,200),(1,300),(1,400)

SELECT  ID
       ,STUFF((SELECT ', ' + CAST(Value AS VARCHAR(10)) [text()]
         FROM @Table1 
         WHERE ID = 1

Posted 24-Mar-17 3:40am

Member 12605293

Updated 24-Mar-17 3:56am

Add a Solution

Comments

Richard MacCutchan 24-Mar-17 9:47am

Um, somewhere in the above code.

Member 12605293 24-Mar-17 9:51am

Hi sir
What is wrong in my code

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bryian Tan · Accepted Answer · 2017-03-24T03:56:00

Solution 1

Not clear what your query is trying to do, look like it is incomplete. I'm guessing this is what you trying to do. Let us know if that not the case.

SQL

DECLARE @Table1 TABLE (ID INT,Value INT)

INSERT INTO @Table1
VALUES (1,100)
	,(1,200)
	,(1,300)
	,(1,400)
	,(2,300)
	,(2,400)

SELECT DISTINCT ID
	,STUFF((
			SELECT ', ' + CAST(ST1.value AS VARCHAR(10)) AS [text()]
			FROM @Table1 st1
			WHERE st1.id = st2.ID
			FOR XML PATH('')
			), 1, 2, '') test
FROM @Table1 ST2
WHERE ST2.ID = 1

Output:

ID	test
1	100, 200, 300, 400

Posted 24-Mar-17 3:56am

Bryian Tan

v2

Comments

Member 12605293 24-Mar-17 10:01am

Hi Bryian
Can I try this query in my db???

Bryian Tan 24-Mar-17 10:04am

Sure. Are you using MS SQL Server?

Member 12605293 24-Mar-17 10:06am

Yes Bryian..I have the same error

Member 12605293 24-Mar-17 10:10am

Hi Bryian,
This is working good