Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Create table from rows of a different table RE: Create table from rows of a different table

  • March 6, 2015 at 3:40 am

    #1782119

    rolinoberto (3/6/2015)

    Hi to every ones,

    I am new to this forum and to SQL world.

    I need your help to find a solution for my headache, my question is:

    I am using SQL SERVER 2012

    I have the following table:

    tbtab1

    | A | B | C |

    | 1 | Pluto | NULL |

    | 2 | Pippo | NULL |

    | 3 | Rossi | NULL |

    I want to creare a new empy table with the columns name contained into the column B of the first table; the following shold my results:

    tbtab2

    | Pluto | Pippo | Rossi |

    Colud you hel on this task?

    Thanks

    What should be the data types (varchar, int, bit etc) of the columns?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.