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

Amit

SOLVED CLOSED ACTIVE ANSWERED
User: Amit
Posted: on Aug 03, 2013 02:31 AM
Forum: SQL Server
Answer: 1
Views: 2735

There are two table with data given below :

Insert value from table 1 to table 2. e.g if value is null then skip else insert.

Table 1

Column A	Column B	Column C
A	NULL	NULL
NULL	B	NULL
NULL	NULL	C

Table2 (Output)

Coumn x

Download FREE API for Word, Excel and PDF in ASP.Net

RkHirpar...

0 3

Reply
ANSWER
User: RkHirpara
Replied: on Aug 04, 2013 11:01 PM
Report

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

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

Company

Explore

Follow us

Contact Us