Thanks a lot...

I got it right..

Here in this procedure i have a problem with date formats. In my data the format is DD-MM-YYYY (13-Aug-1951)

I should declare in my temp table as a string and using date convert i should be able to match it to the date format in employees table...

How do i use a convert function in this procedure and where should i declare it?