Fusion Splicers

Showing 1 - 20 of 29 results for Fusion Splicers
Showing 1 - 20 of 29 results for Fusion Splicers

Fusion Splicers

Fusion splicing is an optical transmission system using solid transmission media. It is the process of joining two media together by butting, and forming an interface between them, and then removing the common surfaces so that there will be no interface left. Thus, there will be no reflection or refraction taking place at the former interface.
DECLARE @PageNumber AS INT, @RowspPage AS INT SET @PageNumber = 1 SET @RowspPage = 20 SELECT * FROM base_model INNER JOIN sub_model ON base_model.CBMD_BASE_MDL_NUMBER = sub_model.CBMD_BASE_MDL_NUMBER WHERE( base_model.CBMD_BASE_MDL_NUMBER IN (	SELECT base_model_category.CBMD_BASE_MDL_NUMBER	FROM base_model_category INNER JOIN sub_category ON base_model_category.MMCSC_SUB_CATEGORY_ID = sub_category.MMCSC_SUB_CATEGORY_ID AND base_model_category.DC_DIVISION_CODE = sub_category.DC_DIVISION_CODE WHERE (sub_category.MMCC_CATEGORY_ID = '303') 		AND (sub_category.MMCSC_SUB_CATEGORY_ID = '3007') AND (sub_category.DC_DIVISION_CODE = '1')	)) ORDER BY (CAST(CAST(sub_model.LIST_PRICE AS float) AS INT))DESC OFFSET ((@PageNumber - 1) * @RowspPage ) ROWS FETCH NEXT (@PageNumber * @RowspPage) ROWS ONLY