Thanks , it was the trigger

no there is is'nt anything at all

Hi , no , there is nothing else , this is what I am wondering

Hi There

So this is my querry

USE [dummy_database]
GO

INSERT INTO [dbo].[FREE04]
           ([TEXT1]
       ...

okay Thanks

Hi, this is test data , I am not into working on production & Thanks alot for the answer ,would be nice if you could test too with the sugegsted...

sorry and what about the FK and PK , do I need to copy them too in new rows ? Thanks

Thanks. How can I ensure for example that rows (that have a TEXT1 = inspektion ) that occur 5 times in the table to be replicated 5 more times and...

DECLARE @ColumnList nvarchar(4000);

SET @ColumnList = STUFF( (SELECT N',' + ac.name
                 ...

Thanks but how do I insert / copy the rows that I have selected in the same table dbo.FREE04 without having duplicate id columns & without messing up Pk &...

Hi yes , the Id column is IDENTITY column