problem how to fusion 2 column

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

This should do the trick:

DECLARE @test-2 TABLE (

D int,

HT int,

Adresse1 char(2),

Adresse2 char(2)

)

INSERT INTO @test-2 VALUES (1,1,'AD','DS')

INSERT INTO @test-2 VALUES (1,2,'BS','HG')

INSERT INTO @test-2 VALUES (1,3,'XD','JH')

SELECT address

FROM @test-2 AS T

UNPIVOT (address FOR addresses IN (Adresse1,Adresse2)) AS U

Hope this helps

Gianluca

-- Gianluca Sartori

d.m.amine Old Hand Points: 312 More actions · Answer 2

Old Hand

Points: 312

April 22, 2010 at 8:37 am

thanks