Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accumulating in a local variable
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00662107
Message ID:
00662126
Views:
23
I don't think it's '+' operator. I would rather suspect that your cursor has 0 records. Check @@CURSOR_ROWS system variable for the number of records in the cursor.

>Thank you Sergey, but it still not working.
>The problem, I belive, is in the '+' string concatenation into SET command.
>Existe other comand similar to SET to concat strings ?
>
>>The fetch command should be at the end of WHILE loop, otherwise you're skipping the first record.
		SET @txt = @txt + @txtaux
>>		FETCH NEXT FROM cur_text INTO @txtaux
>>
>>>I need to accumulate in a local variable a valstring value.
>>>But, for some reason, this not working, the code is:
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform