Hi, I need to populate an empty conformed dimention table from result set of a stored procedure.I would not use all the columns returned but only the required ( may be 7) out of 14 columns the stored procedure returns. However, I may also need to merge the result of stored procedure with another table and then populate the main table ( Conformed Dimension) . Any sugessions about the approach to obtain the result is greatel appreciated!!!!
You can use INSERT EXECUTE, but the number of columns returned by SP should match the prepared table (it could be a temp table with the exact same structure as the expected result).
