CELKO (9/1/2014)
I have the following code and I want to pass more than one value:
DECLARE @myvendedor VARCHAR (255);
SET @my_vendor = '87,30';
Please read any book on RDBMS. In the first 2-3 chapters, you will "First Normal Form" (1NF) and "scalar values"; this is the foundation of RDBMS. We do not do this crap in SQL. Each column is a scalar value, drawn from a domain set.
The only problem is that a parameter is not a table (it could be, but not necessarily). Having that clear, there's no 1NF violation since each value of the column is a scalar value.
By the way, you lost me on the third paragraph of your first article when you wrote "store procedure".