Got it... I added

,@PRIORDATE = CASE WHEN [P].[ID_NUMBER] = @PrevAcctID THEN @CURRDATE ELSE 0 END

Are you talking about the vulcon mind melt?

oh, 1 more thing too please; at each change in the ID_NUMBER, the code isn't setting the first row to 0, it's taking...

You are so smart...

Trying to figure out the order in which to lay things out is tough for me... I get those vulcon mind melts...

Thanks so much,

John

I'm trying to tell him not to use Dynamic SQL

He declares the @DBName and the the @DBSchema [dbo]

the DBName is ok cause we use USE

Only one person runs this SP...

The keeper opens up Access and they are logged into to SQL Server with their XID, maybe even the group permissions...

He doesn't want the Table that is created by this...

Cool, Let me take my foot out of my mouth...lol.

I assume I could put variables in the debugger that are in my Stored Procedure and view their values?

John

I can never start the darn thing (lol) cause the Stored Procedure I want to debug doesn't have any parameters to pass in...

I couldn't find anything to tell me...

I got the error, forgot to join the other table... doh

I'm a bit confused, but check out my post I just posted and my other post, "Recursive"; I think that may be what you want...

Question: Can an UPDATE STAMEMENT be done on a Derived Table while that Derived Table is inserting data into a table...

So in the FROM CLAUSE of the UPDATE STATEMENT, I...

Very glad you pointed it out... Ironicly I had found it the other night, not knowing how significant it was or would be for me...

THANKS...

DOH...

I had to change this for some reason to

@BEG_BAL = CASE ...

Was just thinking, the method is working becuase the RunBal and RunCnt fields are updating... I have to missing somehting...

How do I turn on the trace for this query and shut it off???

thanks,

John

hi,

I thought it was the right way to do it... I'll remember for next time...