Marc,

Thanks for your reply.

I have already gone through MDDE.

MDDE is only supported by SQL SERVER 2005.

The following package elements are currently supported:

Containers

Sequence

For Each...

check this link : http://www.microsoft.com/bi/

Instead of using sub query you can CTE.

Following is code,which will gives you better performance.

WITH Calls_CTE(ID,CallDate)

AS(

SELECT ID,MAX(CallDate) AS CallDate

FROM

dbo.calls

GROUP BY

ID

)

SELECT

customer.ID,

Calls.ID AS FinalCallID,

Calls.CallDate AS FinalCallCallDate,...