Thank you for your fast reply, Jack.

Hi Jack,

I didn't post the original query because the case with the original one was kinda complicated and needed alot of extra explanation which was not necessary for this particular...

Such a tthing doesn't exists. In this project we don't have a WreckageDate. Such a thing is never saved, because it is not entered in any of...

Thank you Jeff,

No, RequestDate and RequestTime are not VARCHAR, just SMALLDATTIME.

They are seperated because RequestTime and RequestDate were just some symbolic names to make my query's structure clear. In my...

Thanks alot.

Is there any way to optimize its performance too?