DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT
WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
WHERE E.GUID='+@guid+' AND E.COMPANY_ID=A.AD_COM AND A.GUID='+@guid+')'')'
print @strsql
EXEC @strsql
EXEC @strsql
==>
EXEC(@strsql)
DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT
WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
WHERE E.GUID='''+@guid+''' AND E.COMPANY_ID=A.AD_COM AND A.GUID='''+@guid+''')'')'
print @strsql
EXEC @strsql
DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT
WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
WHERE E.GUID='+@guid+' AND E.COMPANY_ID=A.AD_COM AND A.GUID='+@guid+')'')'
print @strsql
EXEC(@strsql)
DECLARE @strsql VARCHAR(8000),@guid varchar(10)
SET @guid='1027897'
SET @strsql='SELECT * FROM OPENQUERY(ODB,''SELECT COMPANY_ID,DEPARTMENT_ID,DEPARTMENT_BOSS_GUID FROM GUID_DEPARTMENT
WHERE DEPARTMENT_ID=(SELECT DEPTNO FROM GUID_EMPLOYEE E,GUID_ACCOUNT A
WHERE E.GUID='''+@guid+''' AND E.COMPANY_ID=A.AD_COM AND A.GUID='''+@guid+''')'')'
print @strsql
EXEC (@strsql)
