loop and print 2

[mimi2]

hello,
is there a way i could use a loop to print this:
var1 ='first line'
var2 ='second line'
var3 ='third line'

while @i <= 3
begin
set @new_var = var(i)
print @new_var
end

result:
first line
second line
third line

 

[osjohnm]

Hi

You can use a cursor although there might be another way to do this but I can't think of one.

DECLARE PRINT_CURSOR CURSOR FOR
SELECT var from yourtable

OPEN PRINT_CURSOR
declare @new_var varchar(50)
declare @var varchar(50)

fetch PRINT_CURSOR INTO @var
WHILE @@FETCH_STATUS = 0
begin

set @new_var = @var
print @new_var

FETCH PRINT_CURSOR INTO @var
end

CLOSE PRINT_CURSOR
DEALLOCATE PRINT_CURSOR


Hope this helps
John

 

[grahams]

You can use a WHILE loop in SQL Server - check it out in BOL:

http://msdn.microsoft.com/library/en-us/tsqlref/ts_wa-wz_6oyt.asp?frame=true

Cheers,

Graham

 

[mimi2]

Thanks

 

[cheyney]

If you want to do this with a single select statement:

DECLARE @bigstring = varchar(1000)

SELECT @bigstring = COALESCE(@bigstring + char(13), '') + columnName
FROM tableName
WHERE blah blah

print @bigstring