Adding a column to a production database is a "big deal" here.. and only as a last resort since it would be needed only for this one specialized task..

Thanks for the explanation of the restriction on OUTPUT

The Merge I'll have to look at.. haven't used it before..

Thanks

That would work.. Though I really would prefer a solution that didn't involve locking the whole table...

I wonder why MSFT restricted the Output clause.. is there some technical reason why...

It's the old PK from the where clause that I can't capture. Because SQL doesn't support the type of OUTPUT clause in my example.. It can only output from the...

Never mind.. I was using @User_id as the first argument to the lookup function rather than Parameters!User_id.value

Doing it correctly works..

Ok. Thanks.. saves me a lot of pointless searching..

ok.. that made the tabs appar (I won't even ask at the moment why that should have made the difference..)

But when I try to test the security, it...

1. Was able to create a role and give it full control, and add myself to that role. But all the other tabs are grayed out, (including the CellData...

I guess I'm going to need further directions.. I can't find where in BIDS to set the permissions.

(I've already added the login domain/username to the server role in SSAS, but...

yep.. that seems to be the problem. There must be something I don't understand about the deployment process. Within BIDS I, when I select to process and deploy, it...

Thanks.. I thought about that, but since I need to do a number of lookups like this, merging them each time seemed like a lot of overhead. What I...

Thanks.. looks like this will help..

What finally made it work for me was to cast the varchar(max) field explicitly as a varbinary(max) in the select. Like this:

Select ntpk,

cast(ntNote as varbinary(max)) ntNote

From ...

and then capture...

This should do it.. and I learned some new stuff looking at it..

Thanks

That did it. Thanks!