I just tried to delete this post. I could not.

When you pass a table name as an input parameter to dynamic SQL, it is really impossible. It is like to task DBA with find all parameter values ever passed...

I have some idea how it could be written, but it's not easy to implement.

To parse each word from definition from sys.sql_modules and loop them against all objects in sys.sysobjects.

The...

Thanks Noel. This worked.

SQL Server current versions: C++, some tools C#

Old versions: fortran

I checked BOL, but they don't have examples for it. Only logical_expression.

Thanks all.

This is what I do. I put all tables in another (non-prinmary) filegroup. But since I can't put stored procedures there I script them out. All of these objects...

I DO know all the column in each result set, and I know that they are different. Unfortunately, I also suspected that this is impossible.

But how I can insert data into my_table in the first place ? Numbers of columns for these result sets are different.

Thanks, GSquare, I will try this too.

The reason for this is we have very complex query with huge Where clause. What I suspect is that SQL Server spends a lot more time to build execution plan...

In SSMS/Database/Properties/Filegroups I found my FileGroup, it has 0 under Files column. I pressed Remove button and then OK, but got a message :

Drop failed for FileGroup 'lpad_20090124'. (Microsoft.SqlServer Smo)

Additional...

select nos, max(date1)

from

(

select nos, date1 from #temp union all

select nos, date2 from #temp union all

select nos, date3 from #temp

)t

group by nos

But my problem is that I could not find any file for the filegroup in the first place.

We actually used to have it, David. But there are at least two problems we faced with such kind of allocation.

1. Databases in dev and in prod have the same...