Yup, I agree. Thanks for your time.

Thanks for the reply Scott. If a table does not exist, is...

I checked this up and yes, the tables which are used in the CTE definition (very first query in my first post) are partitioned. The partition is on a column...

I think yes; I'm quite new to this project, so, I will have to check before I confirm. I will update tomorrow.

I want this, I want that - no gratitude?

Update on this:

I and my teammate have concluded that this a SQL bug - not easily reproducible. The initial query, however, always produces wrong result. We ran the same query...

I tried to reproduce the problem using the following query, which does pretty much the same thing (warning: the query will not make any logical sense). However, I could not...

Yes, very interesting. I will need more time to prepare the sample tables. I am not supposed to post the original plan, can get fired for that.

SELECT 'aaa_' + name FROM sys.tables T WHERE type = 'U'

--removed duplicate post

Read this http://www.sqlservercentral.com/blogs/scarydba/2009/09/09/spools-in-execution-plans/

If spooling happens, it will show in the execution plan.

Folks, thanks for the replies. I checked the plan of these queries and figured out that no matching rows were being returned. It didn't dawn on me that I was...

Hey, I'm not querying any user tables to post DDL. You can run the queries I posted on any database.

Edit: I guess you didn't know that information_schema.routines was a...

Thanks a bunch for the reply. I don't have access to the query right now. There is nothing wrong with the query, I suppose, because the generated dtsx runs fine...

Hi Federico, I gave this a try.

We have daily tasks running in our system. Every day at a specific time, we truncate certain tables and repopulate them. We have to...