Hmm it was that simple :hehe:

Thank you very much !

--===== Create the test table with

create table #test

(

id_respondent integer,

projid integer,

gfkroid integer

)

--===== Insert the test data into the test table

insert into #test (id_respondent,gfkroid) values (1234,4567),(2345,4546),(3255,2345)

How the data looks like:

id_respondet |...

I have just read that and tried some queries but I can`t obtain the right result.

I`ll apreciate a little help 😀

Is there anyway to keep the NULL data when UNPIVOT ?

I solved it. Yes, the unpivot was the answer. I used the following query :

select Field from myTable UNPIVOT (Field for ColumnName IN ([unic],[nrc],[nr_tel],[id_stud])) unpvt

Thanks!

Oh sorry..my mistake. In ROWTERMINATOR it is not =/n it is =\ n.

try using bulk insert:

BULK INSERT table_name

FROM 'the adress where your csv is'

WITH

(

FIELDTERMINATOR=';',

ROWTERMINATOR='/n'

)

Nice!

Thanks !