Thank you very Much it will help me a lot..

thanks Again.....

Hi i have already seen the DDL on table SBO_Rehnuma.dbo.OHEM .

But i couldn't found any answer related to this table OHEM..

so please guide me what should i have to do...

Brother this procedure is not written by me it has written by someone else.

and i am a new internee over this organization..

thats y i ask you to solve this issue

thanx

Hi Thanx for your reply..

i got the logic .. but actually i am new in SQL could please write the Code for this using my Code which u can alter...

Here is the code part in which i got error,and also i think i have already mention that it can get the name of employee which have three name like

(first...