Couple of approaches that can be tried :

1. Use OPENROWSET to capture results of @sql. the @sql should be executed within a stored procedure and...

There are three approaches that can be used to solve this problem.

1. Use OPENROWSET - Not all environments allow this approach. This is a security concern.

2. Use of .NET...

More details .....

I have a T-SQL query provided by users of our data, which goes after multiple tables and generates an output. There are multiple queries similar to this...

Additional details :

We are trying to create an audit framework which will run queries as per a particular schedule. These results will be sent in an email. The queries...

The results will be different every time a query is run. Sometimes there might be two columns, and sometimes around 6 to 7.

The query that will be executing will...