Tricky select statement

msreddy13 · #1 (**permalink**) 11-03-10, 23:37

PHP Code:


			
Hi



I have the following data in one of the table 'TestTab'



code,     finished_dtm,     end_dtm

===============================

ABC    (null)        (null)

ABC    2009-08-10    2009-08-10

ABC    2009-08-01    2009-08-09

XYZ    2008-02-04    2008-02-04    



How to write a select satement to return values when



if finished_dtm is null then return that record

else

  return max(end_date) record



thank you

r937 · #2 (**permalink**) 11-04-10, 06:10

you've posted the exact same question in both this forum and the SQL Server forum

you can't be using both database systems at the same time ...

dan.mueller@trnsw · #3 (**permalink**) 11-05-10, 09:59

Why are you trying to sell books here rather than helping the user? This is a forum, not a garage sale.

r937 · #4 (**permalink**) 11-05-10, 10:47

haters gotta hate

it's called a signature, dood

you should get one too

dan.mueller@trnsw · #5 (**permalink**) 11-05-10, 10:59

They probably have medication that would help you.

r937 · #6 (**permalink**) 11-05-10, 11:07

Quote:

Originally Posted by dan.mueller@trnsw

They probably have medication that would help you.

you're just brimming with compassion

like i said, haters gotta hate, and your jealousy doesn't look too good

dan.mueller@trnsw · #7 (**permalink**) 11-05-10, 12:04

Dude, Get over yourself. Jealosy never entered the picture until your obviously overstated opinion of yourself prevailed. And the haters thing? What are you smoking? Where do you come up with this stuff?

My original point (which is still my point) is that someone asked for help and you tried to sell him a book. That (IMHO) rates you right up there with the guys who actually post they will give you more info only if you pay them. Don't you think that type of attitude is missing the whole point of a forum? I certainly do.

As for this ping pong match, you can have it. I am finished with you.

r937 · #8 (**permalink**) 11-05-10, 12:11

Quote:

Originally Posted by dan.mueller@trnsw

... and you tried to sell him a book.

that's ridiculous

obviously you are new to forums and don't understand signatures

Quote:

Originally Posted by dan.mueller@trnsw

I am finished with you.

thank $deity for that

Luis Santos · #9 (**permalink**) 11-17-10, 07:21

Hi,

Wanna use 4gl for that or sql?
If you use 4gl is more easy, with sql i think you should use a function with foreach command.
You can use 4gl for that?

Internet Services

Web Development

Digital Marketing

Consumer Tech