I am trying to get this cursor to work for the second part of the where clause....

or (tran_x like '%12-3107-0049991-00%'

and pitm_c <> '123107004999100')

It isn't inserting any rows....

DECLARE...

I agree, the where clause can be confusing.

The first part t.pitm_c = '123107004999100' is selecting all tranasctions where the account number is '123107004999100'. This will be transactions that are directly...