Hi,

Any reply is a good reply... lol

What data type, I keep getting errors on converting to int... not sure which double precision to use to be able to convert back...

Forgot to add this too...

When I insert into the temp tables, I noticed the execution plans show that it did, sorts, and index inserts (Clustered)...

Why would it do that, when...

LOL... yes it is interesting... lol

Not sure I follow how it's RBAR, and not SET BASED??

Thanks,

John

Hi,

Why does the previos value work on the numbers and not the VARCHAR???

I'm using the UPDATE to tell me my Previos val (which works with the INT), not joining... (also,...

I'm really not sure how to explain any simplier than this...

row 1 VAL = A P_VAL = null

row 2 VAL = B P_VAL = A

row 2 VAL = C P_VAL...

Hi,

Appreciate the reply...

It's for use in a calculation...

but I don't wanna focus on that...

I want the P_VAL to show me what the Prior value was...

thus...

row 1...

Hi,

I found my answer re-reading Jeff Modem articles...

http://www.sqlservercentral.com/articles/T-SQL/68467/

Here is the code I was looking for....

UPDATE

E

SET

@MRN = E.IsCurr =

CASE

WHEN

@MRN = @P_MRN

THEN

@MRN

ELSE

@P_MRN

END

, @P_MRN = e.MRN

FROM

#GETID...

I do...

I really would like to use that update statement I posted at first...

that column I have "Should_Be", is a what I want my out put to look like...

my question...

Hi agian,

I modified your code a bit to get the result I needed... I didn't have to add the Identity row...

I guess to try and explain, when the value A,...

Ahhh,

I have an ID, but I wasn't using it because it's not in sequence, so I didn't think to just add an Identity into my Temp Table...

Thanks for the help!!!

John

Hi,

I inserted the data, as if it were already put in order... so the MRN is my ORDER BY...

With that, if you look at the Update Statement, I have a...

I'll give you that...

So I took the date and ran it against jan 29 2007... what anomaly am I miss that you are trying to point out...

The functions and...

You know what else it is... if i take a months day say 31 and give it to a month with only 30 days, well it doesn't like that... so...

I don't have when the loan was originated or initiated... we are just figuring Principal Payments from Next_Payment_Date on...

I tried all the dates you all mentioned and they came out...

Well it seems to be working... would you care to give me a date that wouldn't work and I can go from there...

No offense, I come here to try and...