asked
can we combine two different stored procedure when each result shows different number of rows
can we combine two different stored procedure when each result shows different number of rows ? please let me know, how can we combine it and when I am using temp table to insert two stored procedures in it, it's showing an error. "Column name or number of supplied values does not match table definition".
different number of rows yes, different number of columns no you will need to pad out with nulls into the missing columns, or do a specific insert into (col1,col2,col5) values (col1,col2,col5) etc in the procs
18 People are following this question.
