Thank you for your help!

CSDunn

Thank you for your help!

CSDunn

This is the code that calls the function;

create procedure dbo.spv_MO_InsertOrder

                    @company                    smallint,

                    @account                    bigint,

                    @seq                        int,

                    @status                     int = 3,

                    @user_code                  nvarchar(20),

                    @contact_type               int,

                    @done_date                  datetime...

Thanks to all for the assistance!

CSDunn

Well, I don't have rights to change the proc. I think what I am left with is some sort of loop that will go through and select each record, and...

The proc will be running against data that is in the same SQL Server 2000 database. I don't know if that answers your question about the data location or not....

I'm thinking I'll probably use SELECT INTO to pull the data from where it needs to come from, then dump it into a temp table.

Thank you for your assistance!

CSDunn

Thank you for your help!

CSDunn

Hey, I was close! Thanks!

CSDunn

Thank you for your help!

CSDunn

Thank you for your help!

CSDunn

Thanks for the help!

CSDunn

Thanks for the suggestion. I wound up abandoning my out file approach after I was able to implement a pretty good solution in the vb6 app using 'Shell and Wait'.

CSDunn

I've got it; I tested for one CASE with an ELSE condition, and CAST 'gr' for each;

"ST_GR" = CASE

When Len(ST.GR)=1 Then '0' + Cast(ST.GR as varchar)

Else CAST(ST.GR as varchar)

End