Steve Jones - SSC Editor (7/3/2012)
Why does the table have to be created on the fly? You know the output of the proc already, so create the temp table using that basis.If you say you want one routine for all procs, you're being lazy. Create routines for each proc that needs this.
Thanks. I am not a developer. I am just trying to come up a solution based on the requirement. I am sure we should go and optimize our queries. This is for a report. You have a sproc to generate report, if you have to query the output of the sproc how would you do that? I would still like to know if the method which i stated is possible or not.