Tim,
The reason I mentioned the 'AS' clause was that I remember previously getting an error that said the dataset was read-only when I did use the rename clause. This would be true because it doesn't see the dataset as 'coming' from a 'real' table. Perhaps the fact that the procedure is using dynamic SQL is causing the problem with MM. If the other procedure that works does not use dynamic SQL then this might suggest this is the problem. Does the other procedure use dynamic SQL?
>Bob, there isn't any columns being named specific but there is a cast in this.
>
>
>/*
> SET NOCOUNT ON;
> DECLARE @SQL varchar(600)
>
> SET @SQL = 'SELECT
> AddressNumber,
> ApartmentNumber,
> LastUpdated,
> LocationID,
> LocationTypeID,
> PostalCode,
> RecordStart,
> Status,
> StreetName,
> UpdatedBy
> FROM [dbo].[Location]
> WHERE
> AddressNumber IN (' + @AddressNumbers + ') OR
> PostalCode = '+CAST(@PostalCode as varchar(10))
> EXEC(@SQL)
>*/
>
>