ID | Data       | XML 
1  | 2014-08-16 | <?xml version="1.0"
2  | 2014-08-16 | <?xml version="1.0"
3  | 2014-08-17 | <?xml version="1.0"
4  | 2014-08-17 | <?xml version="1.0"
5  | 2014-08-18 | <?xml version="1.0"

SELECT Id, dbo.mGetKolSd(Id) AS KolichestvoSD INTO #ColTableTemp FROM Request WHERE Id=@Id 

INSERT INTO #TempTable (Id,Cred,Treb) SELECT
		Id
		,dbo.mGetNum(Id,1)
		,dbo.mGetSdel(Id,1)
		FROM #СolTableTemp

--Результат:
5  | 2014-08-18 | <?xml version="1.0"

--Результат: (примерно)
5  | 1315361      | Нет
5  | 2М31         | Да
5  | 201412       | Нет
5  | 208-18       | Да

SELECT R.Id, ST.Id, ST.Cred, ST.Treb FROM Request AS R OUTER APPLY dbo.mGetProced(R.Id) AS ST WHERE R.tId = @RequestId;

SELECT * FROM Request outer apply (ЗАПРОС) as F(...) WHERE Data >= '2014-08-18'

SELECT D.deptid, D.deptname, D.deptmgrid
    ,ST.empid, ST.empname, ST.mgrid
FROM Departments AS D
    CROSS APPLY fn_getsubtree(D.deptmgrid) AS ST;