SELECT [timesheetID]
      ,(SELECT [name] FROM [Hour_type] WHERE [hour_typeID]=[Timesheet_entry].[hour_typeID]) AS[hour_typeID]
      ,[startTimeStamp]
      ,CASE WHEN endTimeStamp = '0001-01-01 00:00:00.0000000'
      ,[description]

  FROM [TaskManagementSystem_DB].[dbo].[Timesheet_entry]
  WHERE userID= @UserID