Thank you Jeff.

I tweaked code a bit by introducing a view and it worked!

I created a view in ash_test procedure which holds the required output data (that way ignored validation...

Hi Jeff,

Data doesn't get loaded in temp table, fails at EXEC(@tempsql) statement.

Error:

Cannot process the object "exec ash_test". The OLE DB provider "SQLNCLI11" for linked server "(null)" indicates that either the...

Hi Jeff,

Thank you for the suggestions.

In output file, I need to add header and footer.

By loading output of procedure in temp table, I'll derive the header.

Later, use the xp_cmdshell...

Hi Jeff,

Thank you for your reply.

I've a generic procedure which prints messages on screen and used in validation step in other procedures.

Ex: Print error message if querying table doesn't have...

Thank you for the reply Jeff.

If OPENROWSET can return only one result set, why not return it from "inside_proc", which is first statement (EXEC statement) in "ash_test" procedure?

If I place...