Grant here is the Query execution plan :

StmtText

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT MSP_RESOURCES.RES_EUID,MSP_WEB_PROJECTS.PROJ_NAME AS ProjName, MSP_TASKS.TASK_NAME AS TaskName, MSP_WEB_RESOURCES.RES_NAME AS ResName,

MSP_WEB_WORK.WWORK_VALUE / 60000 AS [Work],

CASE

WHEN MSP_WEB_WORK.WWORK_TYPE

(1 row(s) affected)

StmtText

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

|--Sort(ORDER BY:([Expr1043] ASC))

|--Compute Scalar(DEFINE:([Expr1012]=[MSP_WEB_WORK].[WWORK_VALUE]/60000, [Expr1013]=If ([MSP_WEB_WORK].[WWORK_TYPE]=1) then [dbo].[CalculateRealHours]([MSP_WEB_WORK].[WWORK_START], [MSP_WEB_WORK].[WWORK_FINISH], Convert([MSP_WEB_WORK].[WWORK_VALUE]/

|--Merge Join(Inner Join, MERGE:([MSP_WEB_RESOURCES].[WRES_ID], [MSP_WEB_RESOURCES].[RES_EUID])=([MSP_WEB_WORK].[WRES_ID], [MSP_RESOURCES].[RES_EUID]), RESIDUAL:([MSP_WEB_WORK].[WRES_ID]=[MSP_WEB_RESOURCES].[WRES_ID] AND [MSP_WEB_RESOURCES].[RE

|--Clustered Index Scan(OBJECT:([ProjectServer].[dbo].[MSP_WEB_RESOURCES].[PK_MSP_WEB_RESOURCES_WRES_ID]), ORDERED FORWARD)

|--Nested Loops(Inner Join, OUTER REFERENCES:([MSP_WEB_ASSIGNMENTS].[TASK_UID], [MSP_WEB_PROJECTS].[PROJ_ID]) WITH PREFETCH)

|--Sort(ORDER BY:([MSP_WEB_WORK].[WRES_ID] ASC, [MSP_RESOURCES].[RES_EUID] ASC))

| |--Nested Loops(Inner Join, OUTER REFERENCES:([MSP_WEB_PROJECTS].[PROJ_ID]) WITH PREFETCH)

| |--Nested Loops(Inner Join, OUTER REFERENCES:([MSP_WEB_ASSIGNMENTS].[WPROJ_ID]) WITH PREFETCH)

| | |--Bookmark Lookup(BOOKMARK:([Bmk1002]), OBJECT:([ProjectServer].[dbo].[MSP_WEB_ASSIGNMENTS]) WITH PREFETCH)

| | | |--Nested Loops(Inner Join, OUTER REFERENCES:([MSP_WEB_WORK].[WASSN_ID]) WITH PREFETCH)

| | | |--Bookmark Lookup(BOOKMARK:([Bmk1000]), OBJECT:([ProjectServer].[dbo].[MSP_WEB_WORK]) WITH PREFETCH)

| | | | |--Index Scan(OBJECT:([ProjectServer].[dbo].[MSP_WEB_WORK].[PK_MSP_WEB_WORK_WASSN_ID_WWORK_START_WWORK_FINISH_WWORK_TYPE]), WHERE:((datepart(year, [MSP_WEB_WORK].[WWORK_START])=2008 AND datepart(year, [M

| | | |--Index Seek(OBJECT:([ProjectServer].[dbo].[MSP_WEB_ASSIGNMENTS].[PK_MSP_WEB_ASSIGNMENTS_WASSN_ID]), SEEK:([MSP_WEB_ASSIGNMENTS].[WASSN_ID]=[MSP_WEB_WORK].[WASSN_ID]) ORDERED FORWARD)

| | |--Clustered Index Seek(OBJECT:([ProjectServer].[dbo].[MSP_WEB_PROJECTS].[PK_MSP_WEB_PROJECTS_WPROJ_ID]), SEEK:([MSP_WEB_PROJECTS].[WPROJ_ID]=[MSP_WEB_ASSIGNMENTS].[WPROJ_ID]) ORDERED FORWARD)

| |--Filter(WHERE:(like([dbo].[GetInterneExterne]([MSP_RESOURCES].[RES_EUID]), 'Interne', NULL)))

| |--Clustered Index Seek(OBJECT:([ProjectServer].[dbo].[MSP_RESOURCES].[I_MSP_RESOURCES]), SEEK:([MSP_RESOURCES].[PROJ_ID]=[MSP_WEB_PROJECTS].[PROJ_ID]) ORDERED FORWARD)

|--Clustered Index Seek(OBJECT:([ProjectServer].[dbo].[MSP_TASKS].[I_MSP_TASKS]), SEEK:([MSP_TASKS].[PROJ_ID]=[MSP_WEB_PROJECTS].[PROJ_ID] AND [MSP_TASKS].[TASK_UID]=[MSP_WEB_ASSIGNMENTS].[TASK_UID]) ORDERED FORWARD)

(17 row(s) affected)

I tried remoiving the order by function but that did not solve the problem.

Thanks