our database at work doesn't allow for temp tables.
I have a sql query which outputs around 3600 rows with single column, all numeric numbers (1234567, 1234568, 1234569) etc. nearly 3600 which is sent to me, then I compare the same 3600+ rows of data with another table, which eliminates most of those rows and gives me ard 300 rows of final data.
now I copy the same 300 rows into another SQL batch load script to get my work complete.
is there any solution to find a substitute for temporary tables when we have a large dataset to match up, so that we do not have to do WHERE () OR () OR () OR ()?