Thanks Grant,

I will try with TOP and ORDER BY and see the difference.

Thanks again,

Rishi

Thanks Malcolm,

I will check CTE and try to implement the solution.

Thanks

Rishi

Please post a full query and always use hint (NOLOCK) with 'WITH'.

table A WITH (NOLOCK) for example

Cheers,

Rishi

Many times we need to use function 'MAX' in 'Select' clause specially for dates. Does anyone has a thought on different approach.

For example

select max(a.closedate) as closedate, a.offerid

from a...

Greg,

How can we improve the following query?

-------------------------

--------------------------

WHERE

filter 1

...

Hi,

I have a problem and can you suggest a solution without using a cursor.

Problem:

The structure of the Table A is

ID Txt

1 ...

Thanks GAJ, Matt and Jeff for the valuable information on functions usage.

Rishi

Greg, a very nice and useful article.I understand the demerit of using functions in 'Where' clause.

Do/does you/anybody have any idea/s on usage of function in 'Select' clause OR in 'JOINS'...

Jacob - The information given in this article is certainly a food for thought and people can use the option whatever relevant to their context. I have used 'If Exists'...