HI,

first thanks for your help.

I may not understand how to use that but this is what it give me. I mean the @FileExtension should be just ckr, but what do...

Hi thanks that worked.

But now that you mentioned the certificates, where would I be able to learn about that.

What would I look for.

Thanks

Again I apricate the help

Thank you

That worked thanks I really appreciate your help.

Thank you

I think that may be a poor chose of words. Sorry

Because actually I am not sure I can get this to work for me.

They will send in the number of...

Well I meant every month.

But this is great, I never would have thought of this. I know because I have been working for a while and haven't.

Thank you

Sorry, somehow I did not see your reply, maybe I needed to refresh. I will try this now.

Thanks

This is what my code now looks like:

     set @qry='bcp "select * from  ##TEMP1 " queryout "\\DELLX2010\c$\Vend\Inter Data\to ID\DMP " "'+ ...

Trusted connection

Thanks that helped a great deal, but now I am having some kind of issue on the other end. Because it now gives :

"User name not provided, either use -U...

Yes you are right and I thought you should be this totally works but mint does not.

And I agree totlay this should work,  looks like what I am doing too?

But...

Okay, I am working in a VB application and am just, for now, I am just changing the first name. So the other fields would be left blank which if...

Well this is what I have below, and if the parameter is NULL it is wiping it out.

Am I doing it wrong somehow?

UPDATE [dbo].[DebtorACH]
SET first_name = IsNull(@first_name,...

• This reply was modified 4 years, 8 months ago by  itmasterw 60042.

I do not see how you would do this. would you have an example?

Thank you

The problem I ma haveing with your solution is that while it updates waht I want it sets all the other fields to noull wiping out what they had.

I need...

Thanks that looks far better than what I was thinking.

Thank you