I agree with the OP, in fact it's one of my biggest wishes for SQL Server: true "inline" scalar functions or more properly "persistent parametrized scalar expression aliasing".

On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data" refreshes can be pretty hard to get...

This is a CAS (CodeAccessSecurity) permissions error. I think that it means that you are trying to use a DLL that is not approved for your Assembly's safety level.

Are we thinking of the same thing? I thought the concatenation function was pretty...

Carl: can you post your data so that we can replicate your test?

Easiest way is probably to BCP the table and then include as an attachment in a .ZIP...

thanks

Matt: I cannot replicate your results because I cannot find the CLR cursor SP?

Arghh! Right you are, my bad. Thing is, although I thought that it would write more than once (thought I had seen it in a bad Update statement...

So is RC0 a performance-ready version? I would really like to start doing some performance tests on it.

This is one way. Not the fastest, but not terrible, and easy to understand and remember:

--====== capture all of the persons

Select Id, [Name], Cast('' as varchar(255)) as pet_name

Into...

My policy is "Vacation is Vacation", period. If it isn't a real emergency, then I don't want to hear about it and I won't interrupt someone else's vacation with...

Congratulations!

Also, please let the rest of us know the answer?

Or just disable them and see who complains.

Select * from sys.triggers

My question exactly, Jeff.