Oh. Maybe it's been taken down for maintenance. If you do a Google search for it, you can look at the cached version.

John

Ah yes, so they are. Please have a read of this...

http://www.sommarskog.se/dynamic_sql.html

... and decide whether you're still happy with this way of coding. If you are, then what...

I can't find where you're setting the value of @SelectedColumns. This is the important part. You need to get the data types of the columns you are returning...

There has been much discussion on this in the past, some of it rather partisan. Please search for attaching versus restoring, have a read, and then post back if...

OK, so it depends on the data types of the columns returned, not of the parameters. Please post your code and table DDL so that we can help you.

John

What do you mean by size? Do you mean number of rows? If so, use the TOP keyword. If you mean number of KB, I think it's...

Isn't it just that you need to alias your subquery (as Kit originally suggested) - something like this:

select nr_praktijk, naam_praktijk, jaar_k, kwartaal_k, aantal from lvr_praktijken

inner join zsk_kwartalen on nr_praktijk...

Kat

None of us are paid to do this and we do it in our own time, so the easier you make it for us to help you, the more likely...

ddezwaan (12/5/2010)

---

At the risk of sounding like a nit-picking pedant, in international English one says 'more quickly'.

I.e. 'my query runs more quickly', not 'my query runs quicker'

The days of grammatically...

Kat

Please provide table DDL, sample data in the form of INSERT statements and expected results. That way we can visualise your problem properly and give you a tested solution.

Thanks

John

Exactly - so you need to specify which G you want. Qualify your column name so that it is "TP.G" or...

Well, it has a Delete File operation. And you can dynamically define the connection, so you should be able to delete any file pattern you choose.

John

Why are you doing all those conversions on the date column? Can you not just leave them as datetime? I'd guess that's what's killing performance. In order...

How do you know that the individual column used 100GB?

It could be that deleting the column freed a certain amount of space on each data page, but that the table...

I don't think that's possible with the Maintenance Cleanup Task, since it's done on extension only. Have you tried the File System task?

John