Hi,

i have written a udf in sql server 2000 which will return a sql statement e.g.
"SELECT EMP_NAME FROM EMP_MASTER"
I would like to execute this sql in the same function and would like to use the resultset of this sql statement. how can i get resultset of this sql.


e.g.
i have a function like

CREATE function fncGetLogDrildown(@stablename varchar(255), @scolname varchar(500), @spkcolname varchar(255), @lrecid smallint)
returns varchar(2555)
as
BEGIN

DECLARE
@sSql nvarchar(2500)

SELECT @sSql = 'SELECT ' + convert(varchar(255), @scolname) + ' FROM ' + convert(varchar(500),@stablename) + ' WHERE ' + convert(varchar(255), @spkcolname) + '=' + convert(varchar(50),@lrecid)

return @sSql
END

Now, this function will return me a sql e.g. "SELECT EMP_NAME FROM EMP_MASTER" BUT i require the resultset not a sql statement as string.




Thanks and Regards,
vinod

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47201