SQLBill,

QUOTE: Not all the numbers are integers UNQUOTE.

I meant not all values are integer values (1,2,3 ...). There will be 1.15, 2.36 ...

If 1.15 as varchar cannot be converted...

Thanks Brian, we will try that!

JM

I just realized, the pump seems to have run, there is updated data in the destination table. Just no entry in the job log. So it seems to...

OK... this worked!

I have a local Access staging table that I need to get to SQL Server. The ship date field may be left blank by the user in...

Thanks everyone for your suggestions.

In this case a linked table is not an option for me (it's a long story).

Is there an ADO connection property to set to get an...

Thank you Allen but I think I need to clarify. I want the SQL table to store NULL when Access passes an empty date field through ADO. As...

They do drive me crazy.

Do you find yourself leaving the code window to check the name of an object and instantly forgetting how it is written when you get back...

Thanks all for your comments.

So that I don't seem too much the neophyte,

I should explain myself better.

My issue was with the difference between

SELECT notes_key, notes_seq, notes_text, [cust-num], [contact-date], topic, contact...

Thanks for your reply!

I did try OR and got the expected results.

I wonder, is it possible to combine IN and AND in a single WHERE clause?

Thanks again.

Sorry about the delay responding, I do appreciate the help!

Both approaches worked without a noticeable performance difference.

Thanks!

Yes.

The stored procedure properly outputs with the syntax above when I have the correct number of input parameters. I believe you have to declare "Output" both in the procedure...

I think I better have a few more cups of coffee. Thanks Andy, I did not see that.

Jonathan

Thank you Steve, you are absolutely correct of course!

Jonathan

Thanks for the replies,

Unfortunately, I am using SQL 7 (I wish they would spend some $ around here). It sounds like a sp with a return value is the...

Thanks Michael for both of your suggestions.

I bit the bullet and did the brute force conversion. It does not slow things down much at all.

Thanks again

Jonathan