First of all, read my comment.
If your data coming from database, you can use query like that:
DECLARE @myUsers TABLE(UFName NVARCHAR(30), ULName NVARCHAR(50))
INSERT INTO @myUsers (UFName, ULName)
VALUES('Kevin','Smith')
INSERT INTO @myUsers (UFName, ULName)
VALUES('Kevin','Smith')
INSERT INTO @myUsers (UFName, ULName)
VALUES('Kevin','Smith')
INSERT INTO @myUsers (UFName, ULName)
VALUES('Kevin','Smith')
INSERT INTO @myUsers (UFName, ULName)
VALUES('Maciej','Los')
INSERT INTO @myUsers (UFName, ULName)
VALUES('Maciej','Los')
SELECT SRC.[UFName], SRC.[ULName], CONVERT(NVARCHAR(100), SRC.[Nick] + CASE [UserID] WHEN 1 THEN '' ELSE CONVERT(NVARCHAR(10), [UserID]-1) END) AS [UserNick]
FROM(
SELECT ROW_NUMBER() OVER(PARTITION BY [UFName], [ULName] ORDER BY [UFName], [ULName]) AS [UserID], [UFName], [ULName], SUBSTRING([UFName],1,1) + [ULName] AS [Nick]
FROM @myUsers
)AS SRC
Results:
[UFName] [ULName] [Nick]
Kevin Smith KSmith
Kevin Smith KSmith1
Kevin Smith KSmith2
Kevin Smith KSmith3
Maciej Los MLos
Maciej Los MLos1