On Thu, 25 Aug 2005 13:28:50 -0700, "ChrisR" <noemail@bla.com> wrote:
>sql2k sp3a
>
>Dont know if "invert" is the right word, but the only one I could come up
>with. I have a flat file that displays data like:
>
>GEN_PROREGCTCTXT CRZCODE S_GENERATION
>1 CB 1
>1 CS 1
>
>That top row is data, not column names FYI. Anyways, what I need to do is
>get that file into a table but I need it accross, not down. Meaning that the
>rows 2 and 3 from column 1 will actually go into columns 2 and 3 in row 1.
>It needs to look like:
>
>GEN_PROREGCTCTXT 1 1
>CRZCODE CB CS
>S_GENERATION 1 1
>
>Is there a way for DTS to handle something like this? Another good way to do
>it?
>
>TIA, ChrisR
>