Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Update Temp table where the column names are unknown RE: Update Temp table where the column names are unknown

  • December 26, 2013 at 5:57 pm

    #1676033

    DECLARE @cmd VARCHAR(8000)

    SELECT 'UPDATE ##TempTable

    SET [' + ApplicationName +'] = (SELECT SUM(columName)

    FROM RegularTable

    WHERE FORMAT(RegularTable.Date,''MM/yyyy'') = FORMAT(##TempMonths.x,''MM/yyyy''))

    AND ApplicationName = ' + ApplicationName +' '

    PRINT @cmd

    EXEC (@cmd)

    Thanks! I got it to work using your code's syntax.