I will prefer reading the book which is suggested to me before doing any practicals. By the i'll keep patience.

Thanks

Alright! but how does the maintains the log details does it maintain the data in the table or on the physical file.

Thank you Guys.

The problem has been solved.

Your doubt was very correct .

In table emp_dd is month_yr column is carrying on bad data

due to which it was giving the...

Nice solutions but

I tried the both the quries

SELECT DISTINCT CAST(REPLACE(Month_Yr,'/',' ') AS DATETIME) AS Month_Yr

FROM emp_dd

select distinct month_yr,

convert(datetime,'01/' + month_yr,101) from emp_dd

this also gives me the same...