DECLARE @VARIABILE VARCHAR(2)
DECLARE @TSQL VARCHAR(8000)

SELECT  @TSQL = 'SELECT CAMPO1,CAMPO2,CAMPO3,CAMPO_DATA FROM OPENQUERY(HOST,''SELECT * FROM TABELLA WHERE CAMPO7 = 9 OR CAMPO7 = 5 AND CAMPO9= ''''' + @VARIABILE + ''''''')'

EXEC ('INSERT INTO MIA_TABELLA ' + @TSQL)