Hi All

I am facing a problem while executing the following openquery statement I need to store fields values in variables '@DOCNBR' and '@FISCALNO'



SET @SQL = ' SELECT DOCNBR, FISCALNO FROM PJLABHDR WHERE EMPLOYEE ='
+ dbo.quotestring(@pstrEmployeeID) + ''
 SET @SQL= @SQL + ' AND PE_DATE = ' + dbo.quotestring(@pdtWeekEndingDate)
 SET @SQL= @SQL + ' AND LE_STATUS = ''C'' AND LE_TYPE = ''R'''

SET @SQL=N'EXEC sp_executesql select @strDocnbr = DOCNBR, @strFiscalNo = FISCALNO FROM openquery(ORION, ' + dbo.quotestring(@SQL) + ')'


exec (@sql)


for your ref 'dbo.quotestring()' is a function that returns a quoted string..

Help me plz

You can't do it that way, as the variables here have transaction scope and the variables cannot be used outside, in case of dynamic string execution using "exec (@sql)". You need to find alternate way to do that.

_________________________
- Vijay G
Strive for Perfection