gistfile1.txt

ALTER PROCEDURE [dbo].[sp_reset_e360]
AS
	DELETE FROM [dbo].[Tokens];
	DELETE FROM [dbo].[Answers];
	DELETE FROM [dbo].[Responses];
	DELETE FROM [dbo].[Requests];
	DELETE FROM [dbo].[Feedbacks];
	
	DELETE FROM [dbo].[Questions] FROM [dbo].[Questions] q INNER JOIN [dbo].[Questionnaires] qr ON q.QuestionnaireId = qr.Id WHERE qr.Title NOT LIKE '%**NO_DEL**%';
	DELETE FROM [dbo].[Questionnaires] WHERE Title NOT LIKE '%**NO_DEL**%';
	
	DELETE FROM [dbo].[TrustLevelSettings];
	DELETE FROM [dbo].[AppraiseeAssigments];
	DELETE FROM [dbo].[Appraisers];

	DELETE FROM [dbo].[FeedbackInvitations];
	
	DELETE FROM [events].[WinServiceQueue];
	DELETE FROM [events].[EventLog];
GO