text: DECLARE @accountId uniqueidentifier;
  SELECT TOP 1 @accountId=AccountId FROM [Account];
  
  DECLARE @statusId uniqueidentifier;
  SELECT TOP 1 @statusId=ListItemId FROM [ListItem] WHERE Name = 'Active';
  
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Delusions2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Delusions' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Hallucinations2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Hallucinations' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Thought process disorder2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Thought process disorder' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Poverty of thought/speech2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Poverty of thought/speech' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Incoherence of thought/speech2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Incoherence of thought/speech' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Thought block2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Thought block' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Impaired judgment2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Impaired judgment' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Guilt2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Guilt' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Self-blame2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Self-blame' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Blaming others2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Blaming others' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Conspiracy Theories***2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Conspiracy Theories***' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Decreased Meaning of life2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Decreased Meaning of life' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Impaired insight2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Impaired insight' AND a.ParentId = b.ListItemId AND b.Code = 'RealityGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Emotional liability2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Emotional liability' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Fatuousness2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Fatuousness' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Inappropriate affect2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Inappropriate affect' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Bluntness2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Bluntness' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Apathy2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Apathy' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Phobias2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Phobias' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Muscular spasms secondary to Anxiety or Learnt behaviour2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Muscular spasms secondary to Anxiety or Learnt behaviour' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Psychomotor agitation2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Psychomotor agitation' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Psychosomatic disorder2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Psychosomatic disorder' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Somatoform disorder2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Somatoform disorder' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Conversion disorder2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Conversion disorder' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Panic Attacks2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Panic Attacks' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Projection2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Projection' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Denial2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Denial' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Withdrawal2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Withdrawal' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'A-volition2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'A-volition' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Agitation2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Agitation' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Anxiety2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Anxiety' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Inappropriate dress2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Inappropriate dress' AND a.ParentId = b.ListItemId AND b.Code = 'IncongruousActs';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Compulsive behaviour2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Compulsive behaviour' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Obsessional thinking (Obsession)2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Obsessional thinking (Obsession)' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Kleptomania2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Kleptomania' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Preoccupation with Fantasies2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Preoccupation with Fantasies' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Cravings2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Cravings' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Egocentrism2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Egocentrism' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Provocation2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Provocation' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Low level of motivation towards socially negotiated or culturally described behaviour2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Low level of motivation towards socially negotiated or culturally described behaviour' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Poor social judgment2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Poor social judgment' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Withdrawal2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Withdrawal' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Intrusiveness2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Intrusiveness' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Tantrums2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Tantrums' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Rage2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Rage' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Violent2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Violent' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Violence2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Violence' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Aggression2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Aggression' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Allurement2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Allurement' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Seductive Behaviour (Seductiveness)2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Seductive Behaviour (Seductiveness)' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Manipulation2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Manipulation' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Immediate Gratification2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Immediate Gratification' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Childishness2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Childishness' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Over-activity2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Over-activity' AND a.ParentId = b.ListItemId AND b.Code = 'SelfAbsorption';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Emotional abusiveness2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Emotional abusiveness' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Destructiveness against humans, plants, animals or objects2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Destructiveness against humans, plants, animals or objects' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Hostility2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Hostility' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Aggression2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Aggression' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Self- Mutilation or injury2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Self- Mutilation or injury' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Self-neglect (Neglect)2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Self-neglect (Neglect)' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Dietary disorders2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Dietary disorders' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Substance abuse2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Substance abuse' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Willful stealing2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Willful stealing' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Procrastination2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Procrastination' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Hypersomnia2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Hypersomnia' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Insomnia2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Insomnia' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Emotional Dependency2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Emotional Dependency' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Low Frustration Tolerance level2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Low Frustration Tolerance level' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Occasional Suicidal Thoughts2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Occasional Suicidal Thoughts' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Verbal Abusiveness2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Verbal Abusiveness' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Medication abuse2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Medication abuse' AND a.ParentId = b.ListItemId AND b.Code = 'Destructiveness';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Loss or lack of focus2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Loss or lack of focus' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Distractibility2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Distractibility' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Amnesia2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Amnesia' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Blackouts2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Blackouts' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Absent Mindedness2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Absent Mindedness' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Loitering2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Loitering' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Wandering2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Wandering' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Blank attacks2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Blank attacks' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  INSERT INTO ListItem (ParentId,Name,[Description],LastUpdateAccountId, StatusId,LastUpdateTimestamp,Value) SELECT a.ListItemId AS ParentId,'Disorientation2' AS Name,'EMOTIONAL DANGER:  Needs a helper / Not attempting to correct / Not aware' AS [Description],@accountId,@statusId,GETDATE(),'2' FROM [ListItem] AS a JOIN [ListItem] AS b ON a.Name = 'Disorientation' AND a.ParentId = b.ListItemId AND b.Code = 'ConcentrationGaps';
  