SELECT *
INTO ##mytemptable
FROM SomeTable
WHERE [massive where clause, for example]

SELECT * FROM ##mytemptable

DROP TABLE ##mytemptable

@ECHO off

SETLOCAL EnableDelayedExpansion

SET queryFile=%1
SET outFileName=%2

FOR /F "delims=" %%i IN (%queryFile%) DO SET join=!join! %%i

ECHO %join%

bcp "%join%" queryout %outFileName% /S.SQLE_CAESAR /d /c /t"|" /T

PS> $query = @'
    select *
    from <table>
'@
PS> bcp $query queryout <outfile> -d <database> -T -S <server> -c