No it's specific software and the code is compiled and would have no idea where to start if I had access to it.

Tried that, when I use that in the case statement the c.PricingDate shows that it does not exist and I get an incorrect syntax error.

is the Diff columns in the select statement there is an easy to read column for 0 or 0.00000 for decimal.  If there are no changes in the columns across...

Disregard please.  I need to get a better example the max works on this for some reason.

Thanks sgmunson, I'll look into either a tool or Programmatic way to solve the problem.

I could change that, the row is current is for records that have changed (slowly changing dimensions).  I'm wanting to know what year did they pass away by what records...

No, what they are wanting to do is print transcripts for members that are 1/2 through their certification cycle. so if it's a 4 year certification they want to show...

I just found the problem and was coming back to post what I found. For some reason it looked like the DS that I was using somehow got corrupted....

I'll Give that a shot, thank you both for the information

Thank you so much, This worked like a champ ChrisM@Work you rock

My appologies drew.allen

sure, I think I can pull that together, might be later today