Try this

if len(trim(right(sHold,2))) = 1 then

    'trim leading and trailing spaces form values

    sFirst = trim(mid(sHold,1,len(sHold)-2))

    sMiddleInit = trim(right(sHold,2))

else

    iLoc = instr(1,sHold," ",0)

    if iLoc > 0 then

        'middle...

I think your problem is to with you parameter declarations for @RETURN_VALUE1 and @RETURN_VALUE2.

ADO uses @RETURN_VALUE for the return value and even though you used @RETURN_VALUE as an output parameter...

ISQL will produce a fixed column report padded with spaces if necessary.

Are you sure the procs are the same.

SELECT Column1,Column2,Column3 FROM [Table]

will produce

Column1                ,Column2                ,Column3

whereas

SELECT '"'+Column1+'","'+Column2+'","'+Column3+'"' FROM [Table]

will produce

"Column1","Column2","Column3"

Thats OK David glad to help.

Your too kind David.

I know, we try to please.

David

Talking to yourself is the only guaranteed way to get the right answer

Another just for fun but uses a variable

declare @empid int

select @empid = employeeId from

(select top 2 employeeId from employees order by employeeId desc) a

select @empid

Or this

SELECT TENANCYID, SUPPLIERID, EMPLOYEEID, invAmout,

SUM(CASE WHEN itemtype=12 THEN AMOUNT ELSE 0. END) as [openingBalance],

SUM(CASE WHEN itemtype=5  THEN AMOUNT ELSE 0. END) as [payment]

FROM

GROUP BY...

My thought for another attempt was to create a table with a couple dozen varchar(255) fields,

This...

No whinging here  but...

Too vague

You cannot create catalog without enabling Full-Text Search for the database first, there was no mention...

In addition to what has already been posted. I transfer 70+ tables (6+ GB) daily from a third party system and understand your frustration.

These tables are used for reporting and is...

Is PROGEN a sql server?

I get this error when connecting to a third party database using their odbc driver. OPENQUERY works fine but the system will not work with four part...

Well thats EM for you

Yes your's should do the same, however, I wonder if there is a (very) small chance that two processes could generate...

When I tested the code, my tables did not have primary keys or indexes and EM was locked out of both tables and EM showed the tables as locked under...

I had no problems testing this in QA and both my tables were locked.

Did you use just the tsql, you cannot have a procedure with a begin tran without corresponding...

How about this

create Procedure spCreateQuestion(@QuestionName varchar(30))

as

SET NOCOUNT ON

declare @newAnswerId int

declare @newQuestionId int

-- Start Transaction to lock rows

BEGIN TRANSACTION

-- Insert row into Questions and...

What do you mean by does not work, do you get a syntax error or are the results not what you expected.

DTS ActiveX transformations can be written in either VBScript (Visual...