I was looking at it but haven't got a chance for a deeper dive. Will it offer me a completely scripting solution?

Thanks

I ended running the script multiple times until the only errors were related to objects already existing.

Thanks

So I created the boolean type and now I run into the following error:

Msg 15017, Level 16, State 1, Procedure sp_bindrule, Line 104

The rule '[dbo].[BB_rule_BOOL_Value]' does not exist.

I...

You're as helpful as ever Luis.

I should have been more specific. How would I create a proper boolean type without knowledge of how the boolean was defined on the...

Thanks Luis,

I feel like I've been stuck in sql purgatory, just barely knowing enough to get by. I'm really hoping to make the leap to a real developer. I welcome...

I wanted to thank you guys for the suggestions. It's been a while since I've logged on. In the end I using a cursor as we only use a standard...

Thanks so much for the help and education Luis.

Thanks so much for the help and clear explanation. I've read that cursors should be avoided. However, this procedure is actually connected to a larger DTS package which would be...

Thank you. I understand it somewhat more now. There are 2 more parts that confuse me.

What is the relationship between SET @strSellerNo2 = NULL and IF (@strSellerNo2 IS NULL)....