I'm confuse on how I will create my temporary table.
Need some clarification here.
I want to create a temporary table that will hold some column and values. And later on I would alter/update the table to add another column and data with respect to the existing columns.
ammm... how will I do this?
Is it better to create my table were first at hand I will define the columns it needs and just update it or let the select statement define its columns which means I need to alter the temporary table to add the new column?