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 6:51 am

    #1782156

    By chance, is there any reasonable limit of number of TBTAB2 columns needed for the period of the application life ?

    Suppose max is 25 columns. Then create a table with max number of columns

    CREATE TABLE zTBTAB2 (

    i01 INT NULL,

    ...

    i25 INT NULL)

    and recreate VIEW TBTAB2 along with updating TBTAB1 in the application.