Thanq so much for quick reply, but dont know how to write T-SQL function, could you plz write function for CONVERT(Monthnumber)=Monthname

I tried with Back also... not working.

how to get the previous year value to do the calculation.

yes.... by using expression we can do that... but i dont have idea to write expression to get that result... plz help me

In the above example I have taken years(2001,2002,2003) to make you understand, dont hardcode the values.

and how can i get the previous column value?

formula is curyear-prvyear/prvyear*100

No, NO I dont want to handle the report in a query.. I would like to handle in a report, using some custom code,

How to set Regional settings?

ThanQ for your reply and please look at my question once, you would know what exactly i need.

use xml task

I dont have idea about "SQL_Latin1_General_CP1_CI_AS" in sql server, what i need to do to show the desired output in the table. I need it plz....

Sorry... should not use convert to retrive data from date column,

the date should be appear in the table in 01-02-1988 only, not in 1988-02-01.

I agree with you, we can display the result in any desired format using convert or someother functions,

my friend said it is possible to store date in this way '01-02-1988'...

Thanq for your suggestion, but there is a requirement to store date in 'dd-mm-yyyy' in this format only(use only date datatype, dont use varchar), i googled about it , someone...

create table dates(todate date)

insert into dates values('01-02-1988') (or) insert into dates values('1988-02-01')

select * from dates

output:

01-02-1988

I want the output in the above mentioned format,

by default date is stored in table 'yyyy-mm-dd' format , but I want to store date in 'dd-mm-yyyy' format, am i clear?