Problem related to Generate Id like ss1,ss2

You can use Identity[^] property to generate consecutive numbers for each row in database. Later you can append ss to the Id value and display it in your application.
Here is a sample

CREATE TABLE #SampleTable
(
	ID INT IDENTITY(1,1),
	SampleRow VARCHAR(50)
)

INSERT INTO #SampleTable
SELECT 'Row 1' UNION ALL
SELECT 'Row 2' UNION ALL
SELECT 'Row 3' UNION ALL
SELECT 'Row 4' UNION ALL
SELECT 'Row 5' UNION ALL
SELECT 'Row 6' 


SELECT *, 'ss'+ CAST(ID AS VARCHAR) AS Display_ID FROM #SampleTable

DROP TABLE #SampleTable

create table RandomID(CandID as 'SS' + RIGHT(CONVERT(varchar, CourseID),5),
CourseID int IDENTITY(1,1),
ReferrerName varchar(10)
)
INSERT into RandomID VALUES('Technical')
INSERT into RandomID VALUES('Rapist')

SELECT  * FROM RandomID