I understand what you all are saying about the way dates are displayed.

Re: v2008 not having a date attribute. Mine does, unless you're distinguishing between v2008 and v2008 R2. I...

Thank you all! Great help!

Yes, this is better. Thank you all.

Thank you all for input. This one got me what I needed. I apologize for not being clear. I was expecting a zero count if there were no rows. And...

Declaring db owner dbo. - no joy. Yes, the table is empty. That's why I want to get result of 0 zero.

Re: CROSS APPLY ... a totally new one to me. Thanks!

I had to change ORDER BY BatchDateConv to: ORDER BY BatchDatte

Error: ORDER BY items must appear in the select list...

This worked for me, sort of. UAO.InvNo had a few records that were duped which stopped the query. When I deleted the dupes the query ran as expected. Thanks!

INSERT INTO...

Transferring on time would not be a good solution. I thought of that one. Problem is when a record is inserted I may need it in the local table within...

Appreciated, but not using DSN.

Username/password are fake.

Apostrophe for commenting out line understood.

re: error logs. The admin replied they don't show error logs to shared clients.

<%

'REMOTE CONNECT STRING

Set MM_SQL31_STRING = Server.CreateObject("ADODB.Connection")

MM_SQL31_STRING.Provider = "SQLOLEDB"

MM_SQL31_STRING.Properties("Data Source").Value = "SQLB31.webcenter.com"

MM_SQL31_STRING.Properties("Network Library").Value = "dbmssocn"

MM_SQL31_STRING.Properties("Initial Catalog").Value = "ukk"

MM_SQL31_STRING.Properties("User ID").Value = "ukk_admin"

MM_SQL31_STRING.Properties("Password").Value = "ukk2000"

MM_SQL31_STRING.open

%>

Set connOrders = Server.CreateObject("ADODB.Connection")

connOrders.Open(MM_SQL31_STRING) '<-- LINE 111

I found...

Yes

Yes. This same string is use on multiple sites, including the present site. I can read on all...

I need SSIS to automate data transfer and data grooming between our local database and 2 remote databases. Without SSIS I would have to actually work at my job. 😀

PERFECT!!!

Much appreciated!

Not true. I have minimal needs, one of which includes SSIS. That said, what is the least...