Thanks for the replies,

Let me try and clear some things up:

1.  the whole reason i started this thread was because i was trying to write a one time import routine...

Michael,

Address 1 and Address 2 are for line 1 and line 2 of an address respectively.  AddressTypeID differentiates between mailing, billing, shipping addresses...etc...

so one Customer to Address is a one...

So how do you recommend writing reusable code?

Do you recommend the use of Stored Procedures?  If so, how am i supposed to run tests on a value before executing a...

Thanks for all the suggestions, i was able to complete the process without any problems.  Here are my conclusions and questions:

The process completed when I stopped using @@Rowcount in Address_Insert...

I have included 2 more stored procedures to complete the code.

During my testing, i had commented out the execution of the stored procedure:

Exec @ContentSequenceID = ContentSequence_Insert @ContentGroupID=@ContentGroupID, @ContentTypeID=@AddressTypeID

in...

Thanks Brian, and everyone else for your help on this issue.

I threw everything i had at them, and they won't open port 1433 tcp.  I submitted all the documentation above...

So, i informed my ISP that they have blocked 1433 tcp when they really need to block 1434 udp, and they claim that they still won't do anything about it...unless...

Thanks for all the adivce.  I am currently travelling in the arctic...but when i get back i will try and hammer all of this out as i really don't have...

"So in essence, they CAN open tcp/1433 so long as they block udp/1434.

So you're saying if they do this, i can still use server tools like query analyzer and enterprise...

unfortunately, it is a shared server.  So, only thing i can use is the web-based enterprise manager and query analyzer.  Which is harder to use and doesn't allow me to...