SELECT STUFF(( SELECT ','+ RTRIM(aID)
FROM t AS A
WHERE CHARINDEX(RTRIM(bID),TaskIDs) > 0 FOR XML PATH('')),1,1,'') AS Name, TaskIDs
FROM PMS_TaskAllocation AS B这段是在sql2005执行的sql,如何转成sql2000的语句原帖:sql2005 to sql2000 (with关键字)
FROM t AS A
WHERE CHARINDEX(RTRIM(bID),TaskIDs) > 0 FOR XML PATH('')),1,1,'') AS Name, TaskIDs
FROM PMS_TaskAllocation AS B这段是在sql2005执行的sql,如何转成sql2000的语句原帖:sql2005 to sql2000 (with关键字)
SELECT STUFF(( SELECT ','+ RTRIM(aID)
FROM (
SELECT a.ID AS aID,b.id AS bID, b.bGUID
FROM
(
SELECT DISTINCT t.guid, t.ID, ta.guid AS bGUID
FROM dbo.PMS_Task t, dbo.PMS_TaskAllocation ta
WHERE CHARINDEX(','+LTRIM(t.id)+',',','+ta.TaskIDs+',') > 0 and t.projectid = @PKID
) b,
(
SELECT guid, ID FROM dbo.PMS_Task WHERE projectid = @AutoID
) a
WHERE b.guid = a.guid
) A
WHERE CHARINDEX(RTRIM(bID),TaskIDs) > 0 FOR XML PATH('')),1,1,'') AS Name, TaskIDs
FROM PMS_TaskAllocation AS B