Hi Livingston

Thanks

Hi Alan

I have written the query like this . It is working is it o.k

SELECT top 1 u_Month, u_Year, CAST('1-'+CAST(u_month AS varchar(2))+'-'+CAST(u_year AS char(4)) AS date) AS dt

FROM...

Hi

I have below data & i want record with value 6 & 2013 should be returned. Both the fields are numeric

U_MonthU_Year

122012

12013

22013

32013

42013

52013

62013

Thanks

Hi

Just pls guide me i want to display the latest year maximum month value.

Thanks

Hi

I have 3 fields month,year,status. Status will have value 0 or 1

Thanks

Hi

I have 1 more field Status. It should return its value

Thanks