I have a temporary table creating dynamically with N columns. This column count will vary according to some specific conditions (eg: sometimes with count 10, sometimes with count 15...)..Say, the columns names as Jan_2011,Feb_2011. sometimes the column willl reach upto Sep_2011, sometimes to Dec_2011.Now my problem is , I want the sum of all these varying columns . Is there any sql query or we have to pass all these column names as parameters to get the result ?
thanks in advance