How to store multiples values to a column using SET?

Question

1.00/5 (1 vote)

See more:

SQL-server-2000

SQL-Server-2005

, +

Using SET how can i store multiple Values?

When I'm trying to assign multiple values (which are extracted from a database)like this

DECLARE @Level4 varchar(255)

SET @Level4 = '[A,B]'

i'm not getting a proper result.

Can any one let me know how to store multiple values to a particular column?

What I have tried:

DECLARE @Level4 varchar(255)

SET @Level4 = '[A,B]'

Where statement :

(acnt.[Level 4] = @MyAccountLevel4) OR (@MyAccountLevel4 IS NULL)

Posted 16-Jul-20 8:34am

SravanM

Updated 16-Jul-20 21:48pm

Add a Solution

1 solution

Add a Solution

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

Maciej Los · Answer 1 · 2020-07-16T21:48:00

If i understand you well...

You can declare variable type of table:

SQL

DECLARE @tmp TABLE(Column1 As VARCHAR(255))

Then:

SQL

INSERT INTO @tmp (Column1)
SELECT OtherColumn
FROM YourTable
WHERE YetAnotherColumn = 'SomeValue'

To get values from table variable:

SQL

SELECT *
FROM @tmp

For further details, please see: Differences between SQL Server temporary tables and table variables[^]

How to store multiples values to a column using SET?

1 solution

Solution 1

Add your solution here

Preview 0

How to store multiples values to a column using SET?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us