Hi,

Thank you for the Reply, Is there any other way i can do this, Other than IF ELSE and checking @@RowCount.

Thanks a lot..

Here is my SQL Query, This query should not fetch duplicate contactID(i.e Same ContactID).but when i execute the query i get duplicated ContactID. Could anyone tell me what is wrong...

Some sample datas are,

122731

122732

122733

122734

122735

122736

122737

122738

122739

According to the Query the Expected result is,

122734

122738

But i am getting as,

122734

122734

122738

122738

I have a field called MailDate which is in date format. I want to check if the mail date is greater than calender days.

Is there any way to get calender...

Hi,

Thank you for the Reply. I am having SQL2005

Hi,

Thanks for the reply, the code below is working now,

But i have to sort all the datas in the table and then select according to pageIndex,but here...

Thank u So much ill work on it right away.