On Tuesday, January 18, 2005 10:20 AM [GMT+1=CET], Mayer, Stefan <[EMAIL PROTECTED]> wrote:
Da hast Du das Script. Einfach mit dem Query-Analyzer ausf�hren. Aufruf = SELECT dbo.get_Titel(id) <script> if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[get_titel]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[get_titel] GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO CREATE FUNCTION get_titel (@id INT) RETURNS varchar(5000) AS BEGIN DECLARE @cnt INT DECLARE @var VARCHAR(5000) DECLARE @titel_tmp VARCHAR(5000) SELECT @titel_tmp = '' DECLARE rs_cursor CURSOR FOR SELECT ISNULL(O.Titel,'kein Titel') FROM Objekte O LEFT JOIN o2o K ON K.Kind = O.ID WHERE K.LinkTyp = 210 AND K.Kopf = @id OPEN rs_cursor FETCH NEXT FROM rs_cursor INTO @var WHILE @@FETCH_STATUS = 0 BEGIN SELECT @titel_tmp = @titel_tmp + @var + '~' FETCH NEXT FROM rs_cursor INTO @var END CLOSE rs_cursor DEALLOCATE rs_cursor Return @titel_tmp END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO </script> _______________________________________________ Coffeehouse Mailingliste, Postings senden an: [email protected] An-/Abmeldung und Suchfunktion unter: http://www.glengamoi.com/mailman/listinfo/coffeehouse
