路就是把传入的字符串转换成一个table, 见代码
DECLARE @tempTable table(F1 nvarchar(20))
DECLARE @ch nvarchar(20)
DECLARE @PlanningCrewIDS nvarchar(200)
set @PlanningCrewIDS = '1,2,3,4,'
WHILE(@PlanningCrewIDS <>'')
BEGIN
SET @ch = LEFT(@PlanningCrewIDS,Charindex(',',@PlanningCrewIDS,1) -1)
INSERT @tempTable values(@ch)
SET @PlanningCrewIDS = stuff(@PlanningCrewIDS,1,Charindex(',',@PlanningCrewIDS,1),'')
END
SELECT FROM Candidate where IDPlanningCrew in(SELECT F1 FROM @tempTable)