thanks, i need to concate multiple row values into a single row. so i have create proc for this. it's working. but i can't able to call it from my...

If you know any of the following, pls tell me.

Is that any other option for execute the select statement which passed as an argument in the function?

or

can we insert the...

dear kumar..

i knew the basics in SQL. what i m asking is some example for executing sql query which is passed thru another function like follows:

select dbo.test('select colname from table')

so...

hi kumar..

can you give some example for execute select statement wihtin the function.

hi.. this s naga..

i cant able to put insert statement with in the function. how can i do that? please tell me with example..