Martin

Let me see if I can be of a little bit more help. I'm disappointed, but not altogether surprised, that the code you posted is generated by a Microsoft...

Martin

You're declaring table variables (@tbNames etc), which are materialised in tempdb, and comparing data in them with data in your database, which has a different collation from tempdb. Hence...

P Jones (8/7/2013)

---

I always read the email on my 2 x 1920px wide desktop monitors and since the layout change have given up reading from QOTD onwards as it's just...

What is your question?

John

Martin

Yes, open SSMS, connect to your server, click on New Query, paste the query into the ensuing window and press F5.

I've just re-read your original post. Please will you...

martin 7826 (8/5/2013)

---

Thanks very much Simon. I think I actually understand all of that. Useful!

I'm always happy to follow the easy route so I'll try to change the collation of...

The way you've written it, it will return everything that has 'UK' in. If you lose the first '%' then you'll get everything that starts with 'UK'. Some...

There's a last_execution_time column in dm_exec_query_stats.

John

Same with syscomments, which you should...

You need to use Parameter Mapping or result set, not both. If you use Result Set, the results of your query are saved to a variable of type Object,...

Use an output parameter or result set in your Execute SQL task to get the value into a variable, and then user that variable to configure your data flow.

John

Have an Execute SQL task that gets the value you need from the destination, and then configure your data flow so that it only imports the data you require according...

I think if you use your favourite search engine to search for "Is there any query to get the size of all indexes in a database", you'd get the answer...

Whilst that's true in the strictest sense, all but the simplest of packages should...

I'm not totally clear what you're trying to do, but have you tried CROSS JOINing the two tables?

John