Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Microsoft SQL Server, Error:102

Author  Topic 

somenoob
Posting Yak Master

112 Posts

Posted - 2011-09-08 : 23:37:53
-
Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-09 : 03:42:50
[code]
its the quotes
SELECT @SQL = 'SELECT * FROM OPENQUERY(ServerLinkEODWMain,''SELECT TERMINAL_ID
FROM [EODW-Cntr].[dbo].[OPS_DLY_AGING_DTL]
WHERE (TERMINAL_ID = ''BT'')
ORDER BY TERMINAL_ID ASC'')'
[/code]

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-12 : 01:07:57
what about this?

DECLARE @SQL nvarchar(max)

SELECT @SQL = 'SELECT * FROM OPENQUERY(ServerLinkEODWMain,''SELECT TERMINAL_ID
FROM OPS_DLY_AGING_DTL
WHERE (TERMINAL_ID = ''''BT'''')
ORDER BY TERMINAL_ID ASC'')'

PRINT @SQL
EXEC (@SQL)


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-12 : 02:53:21
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_ID
FROM OPS_DLY_AGING_DTL
WHERE TERMINAL_ID = '''''+ @terminal + ''''''')'

PRINT @SQL
EXEC (@SQL)



------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -