Jeffry, thank you for your response.

Tom,

Thank you for your help, I was able to use the 2nd query.

Laura

Hi Sean,

Thank you for your response. Actually I failed to say that I need to pull the last update for each case, for instance

Case 1 has 2 history updates...

Thank you for your help

I tried what you suggested, and I made the temp table #mytemtable, it works fine now.

Laura

Here is the procedure example:

ALTER PROCEDURE [dbo].[My_prodedure] AS

BEGIN

IF EXISTS

(

SELECT *

FROM tempdb.dbo.sysobjects

WHERE ID = OBJECT_ID(N'tempdb..##mytemptable')

)

BEGIN

DROP TABLE ##mytemptable

END

SELECT

a.CUST_ACCNO AS CUST_ACCNO,

a.CUST_TERM_DATE AS CUST_TERM_DATE,

b.ID AS...