As I am new to SQL i cannot understand why you are using the statement

SELECT * INTO #LockHelp FROM Rainfall_Events WITH (TABLOCKX) WHERE 1=2. This statement does not fetch any...

This is an excellent article the gave an idea have to solve some problems that arise from the need of paraller processing. Thank you very very much.

As all we want...