Awesome, thank you very much! A million +1's for you!

Looks like it's missing... I assume in that case it would need to be added.

Awesome, thanks! One last wrinkle: The existing Removable is sometimes null... I need to update when Removable is null or false...

[Plan = "DefaultAddRow" and

Rule = "_" and

(Removable...

Great, thanks! That works for the first CartItem... it needs to look at all CartItems, some of which need to be updated, some don't. the [1] only...

how about a query without setting up all that extra stuff... using only my original ddl and sample data.

That's a lot of great info Celko, but I feel it's way overthought for my situation. This isn't for a business nor do standards or performance matter. I...

Thanks everyone.

If you copy/paste my post into SSMS and run it, the last active result set contains some question marks. ...

declare @activity table (

activity int,

sponsor int,

sibling int);

insert into @activity (activity,sponsor,sibling)

select 0,4,0 union

select 1,4,1 union

select 2,4,2 union

select 3,2,0 union

select 4,2,1 union

select 5,6,0 ;

select *

from @activity;

--notice for each group of sponsor,

--the...

I hope a better description is in my 3rd post below.

We found a reason...

That's them. Thanks.

I deleted the SP from the new db and recreated it; now it's working.

In order to test, I added "exec sp" to the end of the query window......

I found a workaround. I put the following into a batch file:

net use g: \\server\share /user:srv\user pword

dir g:\path\table.dbf /T:A

net use g: /delete

Then changed xp_cmdshell to run the batch file...