CREATE PROCEDURE [dbo].[ResetPartialSearches2] AS BEGIN --Reset status and start timestamp for searches begun but not finished UPDATE dbo.Search2 SET Status = 1, StartDT = NULL WHERE StartDT IS NOT NULL AND EndDT IS NULL; END