Our ERP software was provided for someone that now not exists. And this tables don't matter to us because we don't have the respective application modules. Simply are garbage for...

Thanks very much, the script is very practical and functional.

Best Regards

Thanks, we really need to thinks in the future.

Regards.

I thank to yoy for the script above, it so helpfull to me.

I have the enterprise edition for sql server 2008 and standar for 2000. No aditional problems.

Regards.

Thanks to everybody!!!; I was testing this script in SQL Server 2005 and everthing is ok.

//>>>>

DECLARE @lValueStr VARCHAR(MAX)

SET @lValueStr = NULL

SELECT @lValueStr = COALESCE(@lValueStr + ', ', '')

+ a.Cod_Asignatura...

Thanks,

I understand Dynamic SQL, but I need to get result to update another field in another table. The Dynamic SQL just execute it self on the fly and that's all.

How...

hEY, Thanks so much!!!! Everything it's ok.

THis Is New for me 'cause I was working hard in SQLServer2000.

I was looking for a solucition like you suggest for sqlserver2000 enviroment because...