pears.RemoveDeletedQuestion [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.RemoveDeletedQuestion ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."RemoveDeletedQuestion"()
/* Application Maintained Function / Procedure - DO NOT EDIT*/
begin
  delete from "DeletedTag" where "datediff"("day","WhenDeleted",current date) > 200;
  delete from "DeletedTagChoice" where "datediff"("day","WhenDeleted",current date) > 200;
  delete from "DeletedTagValue" where "datediff"("day","WhenDeleted",current date) > 200;
  delete from "DeletedTagCompliance" where "datediff"("day","WhenDeleted",current date) > 200;
  delete from "DeletedCriterion" where "datediff"("day","WhenDeleted",current date) > 200;
  delete from "DeletedDocumentTag" where "datediff"("day","WhenDeleted",current date) > 200;
  delete from "DeletedDepartmentTag" where "datediff"("day","WhenDeleted",current date) > 200;
  delete from "DeletedReferenceMasterQuestion" where "datediff"("day","WhenDeleted",current date) > 200;
  if exists(select * from "sys"."systable" where "table_name" = 'DeletedIQXNetTagGroupMember') then
    delete from "DeletedIQXNetTagGroupMember" where "datediff"("day","WhenDeleted",current date) > 200
  end if
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."RemoveDeletedQuestion" IS 
{create procedure RemoveDeletedQuestion 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

( )
begin
  delete from DeletedTag where datediff(day,WhenDeleted, current date) > 200;
  delete from DeletedTagChoice where datediff(day,WhenDeleted, current date) > 200;
  delete from DeletedTagValue where datediff(day,WhenDeleted, current date) > 200;
  delete from DeletedTagCompliance where datediff(day,WhenDeleted, current date) > 200;
  delete from DeletedCriterion where datediff(day,WhenDeleted, current date) > 200;
  delete from DeletedDocumentTag where datediff(day,WhenDeleted, current date) > 200;
  delete from DeletedDepartmentTag where datediff(day,WhenDeleted, current date) > 200;
  delete from DeletedReferenceMasterQuestion where datediff(day,WhenDeleted, current date) > 200;
  if exists (select * from sys.systable where table_name= 'DeletedIQXNetTagGroupMember') then
     delete from DeletedIQXNetTagGroupMember where datediff(day,WhenDeleted, current date) > 200
  end if;
end
}
</code>