What is the best way to execute this script?

Jon,

Great article!

Now that you've done all that work, would you mind sharing your top 5 choices?

TIA.

Well, requiring English was/is just a suggestion.  It's not personal -- it was meant to benefit most members.

Just to be clear, I didn't say, nor do I expect, that anyone...

Frank,

>>Would it be an alternative to use a middle layer and do the transition there?<<

Exactly.  There are some operations I would have preferred to do on SQL Server, but can...

Frank,

I believe you are the one who is being harsh -- continuning to offer comments about things of which you have very little information.

FYI, I am a solution provider.  Neither...

Frank,

You're entitled to your opinion, but you might want to gather the necessary information before you make such a profound judgement.

You have no idea of what I'm trying to accomplish,...

JP,

Thanks.

I get the following error:

EXECUTE cannot be used as a source when inserting into a table variable.

Jim

Journeyman,

Thanks for the suggestion, but it doesn't seem to return what I need.  For example:

DECLARE @DisplayValue AS VARCHAR(255),

  @ItemType AS VARCHAR(255)

DECLARE @ReturnValue AS sql_variant

SET @DisplayValue = '123.12'

SET @ItemType = 'decimal(6,2)'

 ...

Noel,

What front end tool would you use?

Ilmar,

This is probably not the answer you want to hear, but you will probably be better off in the long run to recode you VFP SQL using as much native...

Calvin,

This is perfect!!!!  Exactly what I was looking for.

Thank you very much.

This is a little off-topic.  Your modivation for creating a system SP was to have it available to all DBs.  I have a similar question with regard to UDFs.

Is it...

Enjoyed your article Joseph.

FYI, the page title that appears in the window title bar is:

"Capturing The Error Description In A Stored Procedure"

I find this article unreadable.

The very wide image causes the text to spread out so far to the right that excessive horizontal scrolling is needed.  So, as you read each...