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...

Got it Sean, Thanks!

Thanks Dave!

Thank you Sean!

I have tried something like this:

select program, pstatus, form from

(select * ,

ROW_NUMBER() over (partition by program order by len(form)) as RowNum

from #pt

group by program, pstatus, form) x...

Thank you Drew!

Thank you all for your comments, All very helpful articles and book for a newbie.

This is not an exercise Celko, I am a SQL newbie. Thank you for the comment and suggesting the book.

Thanks Chris!

Thanks you Jeff!

Thanks Malleswarareddy!

Thank you mhike2hale!