34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT EM007 FROM [EAPS].[dbo].APSEMP WHERE EM001 = 'hs'
'加工中心1','加工中心2','加工中心3'
SELECT
[JO002]
,[JO003]
FROM [EAPS].[dbo].[APSJOB]
where
JO015 IN ('加工中心1','加工中心2','加工中心3')
SELECT
[JO002]
,[JO003]
FROM [EAPS].[dbo].[APSJOB]
where
JO015 IN (SELECT EM007 FROM [EAPS].[dbo].APSEMP WHERE EM001 = 'hs')
DECLARE @STR VARCHAR(200)
SET @STR=''
SELECT @STR=EM007 FROM [EAPS].[dbo].APSEMP WHERE EM001 = 'hs'
EXEC('
SELECT
[JO002]
,[JO003]
FROM [EAPS].[dbo].[APSJOB]
where
JO015 IN ('+@STR+')'
SELECT [JO002],
[JO003]
FROM [EAPS].[dbo].[APSJOB] TA
WHERE EXISTS (
SELECT 1
FROM [EAPS].[dbo].APSEMP TB
WHERE TB.EM001 = 'hs'
AND TA.J0015 = TB.EM007
)
DECLARE @STR VARCHAR(200)
SET @STR=''
EXEC('
SELECT @STR=EM007 FROM [EAPS].[dbo].APSEMP WHERE EM001 = ''''hs'''''
SELECT
[JO002]
,[JO003]
FROM [EAPS].[dbo].[APSJOB]
where
JO015 IN ('+@STR+')'
declare @sql nvarchar(4000)
set @sql = 'SELECT
[JO002]
,[JO003]
FROM [EAPS].[dbo].[APSJOB]
where
JO015 IN ('+SELECT EM007 FROM [EAPS].[dbo].APSEMP WHERE EM001 = 'hs'+')'
exec(@sql)
SELECT
[JO002]
,[JO003]
FROM [EAPS].[dbo].[APSJOB]
where CHARINDEX(JO015,(SELECT EM007 FROM [EAPS].[dbo].APSEMP WHERE EM001 = 'hs')) > 0