Hey peeps i am an sql novice and would like to ask for some assistance!
i have succesfully read the contents of a horizontal filled text file and inserted them into sql using Bulk insert! but my aim is to make this horizontal table a vertical one! Text file:
0,1,2 in SQL:
should i first load it horizontally and then change it to vertical? and how?
or is there a way to directly read from horizontal text file and insert vertically?
thank you for ur help!
select 'flex' as flextype, flex as flexvalue from yourtable
select 'flex1' as flextype, flex1 as flexvalue from yourtable
select 'flex2' as flextype, flex2 as flexvalue from yourtable
If it's not practically useful, then it's practically useless.