Population table from result obtained by a stored procedure RRS feed

  • Question

  • 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!!!!
    Wednesday, March 17, 2010 2:10 AM