Thank you very much.
I changed my Stored Procedure to this:
DECLARE @MyString NVARCHAR(3);
SELECT CASE
WHEN 1 = 1
THEN 'One is equal to one'
END
SELECT @MyString = 'foo'
SELECT @MyString
Now I have this two lovely outputs:
'One is equal to one'
'foo'
I thought SELECT returns values and SET populating the variable with the values.
For example:
SET @MyString = 'foo'
___________________________________
Computer Enterprise Masoud Keshavarz
I don't care about hell.
If I go there I've played enough Diablo to know how to fight my way out.