In this case the 100k return does not actually leave the server, it is used in a SP.

Improvement how? (he asked defensivly )

Couldn't you:

1. Check week day

2. If Monday to Thursday check month of next day

3. If Friday check month of monday

I do not know what kind of holidays that you/the...

Isolation levels regulate how other users (processes?) can access data that you are accessing - like reading from a table for example.

If your server is dragging maybe someone uses an...

You could also do an export (defined by a query) directly to Excel.

/HL

Couldn't you use EXEC[UTE]?

Personally I think that executing dynamic SQL in a stored procedure defeats the purpose of a stored procedure, perhaps doing this in the code would be better?

/HL

I considered that solution, but rejected it as not elegant enough

To me, if I'm going to using such a solution, it seemed better...

It involves me being allergic to doing anything with an interface . The column names in my question is displayed in a datagrid control.

I...