Insert Not NULL Values from 3 columns of one Table into single column of another Table in SQL Server

Hi amit,

Please try following code sample for that,

DECLARE @tbl TABLE
(
	COLUMN_A VARCHAR(100)
	,COLUMN_B VARCHAR(100)
	,COLUMN_C VARCHAR(100)
)

INSERT INTO @tbl
SELECT 'A', NULL, NULL
UNION ALL
SELECT  NULL,'B', NULL
UNION ALL
SELECT  NULL, NULL, 'C'

SELECT COALESCE(COLUMN_A, COLUMN_B, COLUMN_C) AS COLUMN_X FROM @tbl

Thanks and Regards,

Rk_Hirpara