TEJABI (1/29/2016)

---

create table UserName (FirstName varchar(50),LastName varchar(50))

insert into Username select 'Abhas' ,'Jadhav'

Union

select 'Ashwin' ,'Jadhav'

UNION

select 'Akash','Jadhav'

UNION

select 'Bbhas' ,'Jadhav'

Union

select 'Bshwin' ,'Jadhav'

UNION

select 'Bkash','Jadhav'

with cte as

(

select newid () sysid ,(SUBSTRING(FirstName,1,1)) firstname ,lastname from username

),

cte2 as

(

select sysid,firstname,lastname,convert (varchar(100),ROW_NUMBER() over(partition by firstname,lastname order by sysid)) as rownumber from cte

)

select (firstname + lastname + replace((rownumber -1),0,'')) as fullname from cte2