THanks for your feedback

bump

Good point!

Here it is...

select h.historyid, h.startdate,a.account,h.description,h.longnotes, a.address1, a.city, a.state, a.postalcode, h.category

from sysdba.history h

join sysdba.account a on a.accountid = h.accountid

join sysdba.address r on r.addressid = a.addressid

ALZDBA (8/31/2009)

---

That's because you have the condition on the SAP_Cust in the where clause, so are excluding NULLs (which are the non matching)

Alter your where clause to

WHERE dbo_SAP_CUST.KUNNR < '0000900000'

...

My apologies I should have given some of the backstory here. I've gone thru CDW whom we have a relationship with on past purchases but I'm not sure the pricing...

It does thanks, we use bcp for importing files that are consistent in nature but this is a different animal where the file layout is dynamic?

Richard

Thanks for the suggestion, would you have an idea for how the TSQL would be structured that would be able to "read" the Excel file layout? Here's an example of...

Much thanks to you both and Matt your tag line is one of my favorite sayings!

Chris thanks for the fast reply. I get a syntax error near 'getdate'.

I thought maybe it was due to a space needed between -1 and the first getdate but that...

Odd that my PM says "InBox (0/0)" please email me at ronkoppelmann@gmail.com

PM Sent

Lester,

Thanks this was helpful to me on a related matter...

Ron

Lester Policarpio (11/21/2007)

---

dhara is right you can use DTS for transferring tables but if you want to use a script there...

Thanks, I've rebuilt the...

http://www.sqldev.net/xp/xpsmtp.htm

A quick thank you to those who posted help here, I was able to resolve a similar issue with the advice listed here and a search of the forums!