Thank you all for the posts and thoughts to consider!

Thanks for all the posts!  I'll look into them.

The primary purpose will be to read and write data to the database.  Since the communication must take place between two separate networks, I'm curious which means to establish the...

Ugh, my session expired after typing my post! 

I do have a master proc but not until after recompiling the code.  I must not have tried the #temp table since...

Holy cow, what an abundance of help.  I really appreciate them all!

I generally use #temptables, however, in this app, those tables drop off after the sproc that created them has finished executing. ...

Thanks for following along with me on this.  I really appreciate it!

I can verify that it is datetime.  Unfortunately, the execution plan does not give much to go on.  I'll...

Thank you, Sergiy.  I understand I must compare with same datatypes, but I am failing at doing this with my parameter.  What change must I make?  I've change the parameter...

It is a datetime field.

That's great, thanks so much for your post!

Thanks for the replies!

Thanks for the post! 

The problem is related to user capabilities with the software.  That and the support is my main concern.  Though this is being built for an individual,...

All great points and I greatly appreciate it!  I ended up using, "@command = @commandValue," and setting the @commandValue to include the exec and parameters together:

Set @commandValue = "EXEC DevDatabase.dbo.spProcess...

Aah, my eyes have deceived me!  Thank you.

Got it, thanks!

Get suggestion, thanks!!