Yes Lynn Pettis.

Thanks for the reply Lynn Pettis.

There are two records with a value of '1' for column c1, t1 value for those records is null where as t2 has values as...

ColdCoffee (7/17/2012)

---

ssc_san (7/17/2012)

---

ColdCoffee (7/17/2012)

---

Meaning, 0,9,13,14,16 will...

ColdCoffee (7/17/2012)

---

Meaning, 0,9,13,14,16 will have other...

Thanks for the query Coldcoffee.

We have a issue here, they may add other adjustment periods in the future, so it is not a fixed set of periods.

Any other method...

Try this:

DECLARE @testagg TABLE

(

id VARCHAR(10),

nm VARCHAR(20),

amt INT...

Thanks for the reply Sean Lange.

Sure, the py_fl (prior period flag) is set to true for pr (period) 16 (Fiscal year 2012), and the adfl (adjustment flag) is true for...

As they are going to change the input method,...

Evil Kraig F (6/21/2012)

---

If these fields are all the exact same length than what's posted above by Lynn will work. I'm afraid I don't necessarily agree with Lynn about...

Thank you Lynn.

You haven't answered the question, how does a SQL query know that '01-' is supposed to be '001' not '010'? You have said that '010' is not a...

Lynn Pettis (6/21/2012)

---

ssc_san (6/21/2012)

---

Here is my problem, I would expect you want '010' not '007' if the '-' in '01-' were a '0', why would you expect '01-' to be...

Lynn,...

Thank you all for the replies.

Here is the sample code, I am trying to get the Max three letter field and date associated to it, the query mentioned in the...

Thanks Lynn for the reply.

I am trying to extract a part of string and with in that I need the max value for ID associated to it. As the string...

Thanks for the reply Stewart!

I have to test and make sure, I don't have any other cases that are missing.

Thanks again!