Here i had created one function for returning the value of the Name from ListOption table.

CREATE FUNCTION [dbo].[GetListOptionDetails]

(

@fListOptionID int

)

RETURNS nvarchar(255)

AS

BEGIN

RETURN (SELECT Name from ListOption where Id = @fListOptionID)

END

SELECT...