> DECLARE @textFeld nvarchar(50), @myText nvarChar(4000) > DECLARE a_cursor SCROLL CURSOR > FOR > SELECT TextFeld FROM Tabelle WHERE ID > 2 > OPEN a_cursor > FETCH NEXT > FROM a_cursor > INTO @textFeld > SELECT @myText = '' > WHILE @@fetch_status = 0 > BEGIN > IF (LEN(@myText) < 2) > BEGIN > SELECT @myText = @textFeld > END ELSE > BEGIN > SELECT @myText = @myText + ', ' + @textFeld > END > > FETCH NEXT FROM a_cursor INTO @textFeld > END > DEALLOCATE a_cursor >
in Verbindung mit einem Trigger klappt das super, danke nochmal Gruss Alex www.aspintranet.de ~~~~~~~~~~~~~~~~~~~~~~~~~~~sponsored by United Planet~~~~~~~~~~~~~~~~~ Intrexx.BizWalker + ODBC/OLEDB-Daten = ASP-Formular ATTACK! Download Intrexx CRM-Studio Now! http://www.intrexx.com _______________________________________________ Database.asp mailing list [EMAIL PROTECTED] http://www.glengamoi.com/mailman/listinfo/database.asp
