CONCATINATION - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

CONCATINATION

Author

Topic

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2007-02-07 : 12:33:19

Hi
using
declare @a int,
@b int
set @a=0
while @a< 20

begin
set @a=@a+1
print @a

end
i am getting result
1
2
3
.
.
.20
but i want to concatenate like this 1,2,3,4,-------,20

please suggest me

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-07 : 13:22:24

[code]DECLARE @s VARCHAR(59)

SELECT @s = ISNULL(@s + ',', '') + CAST(Number AS VARCHAR)
FROM (
SELECT Number
FROM master..spt_values
WHERE Name IS NULL
AND Number BETWEEN 1 AND 20
) AS d

SELECT @s[/code]

Peter Larsson
Helsingborg, Sweden

monty
Posting Yak Master

130 Posts

Posted - 2007-02-08 : 00:58:55

thnx peso

its me monty

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources