I have to export the records of a table in a .txt file but in a strange way (in a column). For example I have this table with 3 fields:
create table prova
des2 Varchar (2)
insert into prova values (1, 'A1', 'A2')
insert into prova values (2, 'B1', 'B2')
I need to have the output in this way:
1 cod 1
1 des1 A1
1 des2 A2
1 cod 2
1 des1 B1
1 des2 B2
So, I have to put '1' at the begining of every field and '8 S' at the end of every record.
Anyboody helps me to do this?
Thank you very much.