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 rows?
I't must be somenthing about the lock time, bit can you explain me why you are using "WHERE 1=2"?
Thank you