do like......SELECT @SQL = 'SELECT * FROM OPENQUERY(ServerLinkEODWMain,''SELECT TERMINAL_ID,CNTR_N,CNTR_TYPE_C,DERIVED_CNTR_TYPE_C,DG_GROUP_C,DG_IMO_CLASS_C,LENGTH_Q,LOAD_SPECIAL_DETAIL_X,CNTR_ST_C,CNTR_OPR_C,DIRECT_LOAD_I,DIRECT_DELIVERY_I,UC_I,ISO_SIZE_TYPE_C,REEFER_TEMP_Q,PURP_C,DERIVED_CNTR_PURP_C,COMMODITY_C,LOCATION_C,BLOCK_N,SLOT_FROM_N,SLOT_TO_N,ROW_N,LEVEL_N,LOAD_PORT_C,DEST_PORT_C,DISC_PORT1_C,DISC_PORT2_C,DISC_PORT3_C,ARIV_DT,EXIT_DT,DISC_DT,LOAD_DT,DISC_ABBR_VESSEL_M,LOAD_ABBR_VESSEL_M,DISC_ABBR_VOYAGE_IN_N,LOAD_ABBR_VOYAGE_OUT_N,CAT_C,LOAD_CONNECTION_ST_C,INSTRUCTION_TYPE_C,STAY_DAYS_Q,INTERGATEWAY_I,BATCH_IDFROM OPS_DLY_AGING_DTLWHERE TERMINAL_ID = '''''+ @terminal + ''''''')'PRINT @SQLEXEC (@SQL)
------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/