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!

Try this:

SELECT

A.Account,

A.Symbol,

A.PandL,

Min(A.Timee),

CASE

WHEN Min(A.Timee) BETWEEN '00:00:01' AND '09:30:00' THEN 'BeforeMktOpen'

WHEN Min(A.timee) BETWEEN '09:30:00' AND '10:00:00' THEN 'FirstHalfHour'

WHEN Min(A.timee) BETWEEN '10:00:00' AND '15:30:00' THEN 'Day'

WHEN Min(A.timee) BETWEEN '15:30:00' AND '16:00:00' THEN 'LastHalfHour'

ELSE...

Thank you dwain!

Thank you Howard!

You are correct, I was looking for the same output you query provided.

Thank you Paul!

Thank you Adi!

Hi Jeff,

I am using it to populate list of values for my report. And it is not going to change in the future (As per User), So I took Sean's...