getting multiple results into a single field

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

how to get multiple results fetched from a query into single field??

i am trying this...

SQL

declare @uname varchar(max)
select @uname = (select uname from users)

but it is wrong...
so could anyone tell me the right way to do this??

Posted 1-Jan-12 21:56pm

Sachin gulati

Updated 1-Jan-12 21:58pm

Mehdi Gholam

v2

Add a Solution

4 solutions

Solution 1

A select statement cannot be assigned to a scalar variable like this.

You can however create a TABLE variable, see here for examples :
http://odetocode.com/code/365.aspx[^]

Posted 1-Jan-12 22:00pm

Mehdi Gholam

Comments

Wendelius 2-Jan-12 4:01am

That's a good possibility, 5.

Mehdi Gholam 2-Jan-12 4:02am

Thanks

OriginalGriff 2-Jan-12 5:03am

Um. You can...
DECLARE @data NVARCHAR(MAX)
SET @data =
(SELECT Id + ', ' AS 'data()'
FROM Test
FOR XML PATH(''))
PRINT @data

Sachin gulati 2-Jan-12 6:05am

thank you... :)

Solution 3

use cursor for that if u don't know about i can write a code for cursor

Posted 1-Jan-12 22:03pm

Tanveer A

Solution 4

Try:

SQL

select myColumn + ', ' as 'data()' from myTable for xml path('')

Posted 1-Jan-12 22:05pm

OriginalGriff

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)

Wendelius · Accepted Answer · 2012-01-01T22:00:00

Solution 2

You cannot place multiple items in a single variable. One way to do this is to iterate the results using a cursor. See: DECLARE CURSOR [^].

However, if possible, what ever you're doing, it would be more efficient if the operation could be done set based.

Posted 1-Jan-12 22:00pm

Wendelius

Comments

Mehdi Gholam 2-Jan-12 4:03am

Yes, cursors are probably what the OP wants. 5'ed

Wendelius 2-Jan-12 4:04am

Thank you :)

Sachin gulati 2-Jan-12 6:06am

it worked... thanx alot... :)

Wendelius 2-Jan-12 12:35pm

You're welcome :)

Sachin gulati 2-Jan-12 12:26pm

can i make cursor permanent in memory?

Wendelius 2-Jan-12 12:35pm

I'll answer that in your other question.