Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 12:42:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

No i haven't used any delimiter,

used the below format query ..

     SELECT COL1,COL2,COL3.....COLN FROM TABLE_NAME;

Below are the sample screenshot, for testing purpose i used only 2 columns whereas in the real scenario there are 10 columns.

DC_SOQ_ERR_ID & CRT_PGM are 2 different columns i want it in different cellls whereas it falls in the same cell..

     DC_SOQ_ERR_ID   CRT_PGM_
     -------------   --------
              1956   DCFR_PPO
              1752   DCFR_PPO
              2263   DCFR_PPO
               713   DCFR_PPO
              1264   DCFR_PPO
              2814   DCFR_PPO
                61   DCFR_PPO

Thanks

Naveed

	<Prev	Next>		<<First	<Prev	Next>	Last>>