• 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