yes, my misclick. u can remove this topic, please

these are the functions:

/*

Split()quebrar uma string com valores delimitados por 1 caractere

@param inputstring delimitada

@param delimiterdelimitador com 1 caractere qualquer

@return outputtable output{valor}

@usageSELECT valor FROM Split( 'aa;bb;ff;xx;', '|' )

*/

ALTER FUNCTION Split(...

O.o

it worked!!!!

SELECT dbo.testList( '14;0;-1;-2;', ';' ) as rolenames

rolenames

---------------------------------

Administrators - All Users - Host

\o/

i know it might be a stupid...

hmm now I put all into a function. the split() works fine.

but something at the last rows are not right. It error:

"Server: Msg 2010, Level 16, State 1, Procedure...

i look like the picture =^.^=

it can run slowly if it at least run hehehe the problem is when i put all functions together ( are 3 ), and call the functions caller into...

thats the point. these negative ids are not inside the roles tables ( who knows the guy who did that please kill him for me! (dotnetnuke's crazy people) )

my darling!...

nicolas! hi!

I tried this function you said, and it worked!!! No need cursor and dynamic query anymore! yay! \o/

Now i'm trying to...

split function that generate the first table result:

create FUNCTION Split( @input VARCHAR(1000), @delimiter CHAR(1) = '|' )

RETURNS @output TABLE( valor VARCHAR(1000) )

AS

BEGIN

DECLARE @join VARCHAR(1000)

DECLARE...

sample data: '14;-3;11;' ( n id values comma delimited ) like:

main_table

----------

roles otherfields

14;-3;11; ...

roles_table

-----------

id description

14 Administrator

-3 Administrator

11 Customers

expected...

i dont know how to do this.

the main query will bring many rows, and for each row I will have to get the delimited ids converted to their descriptions, i...

because i dont want to do many steps to convert some ids to their values. this way, I would have to code much more, and in the client application.

i do...

oh boy thats sad ((

If I can make a proc work like a function but can't use it results anywhere it what's the point...

/cry

now i found another issue.

as a function I could call like this:

select myfunction(args),fields from table

now with the procedure call like this:

declare @x varchar(2000)

exec dbo.procJoinColuna 'rolename','14;0;-1;-2;',';', @x OUTPUT select @x

this code...

ah i did some tests and now it works

SET @cr_sql = 'DECLARE cursor_join CURSOR FOR SELECT DISTINCT( '+ @coluna +' ) FROM Split2Table( '''+ @valor +''', '''+...