Query seems to be fine ...Can you try creating DSN using ODBC driver with the following credentials and check if you are still able to access the database.

And pls dont give...

Pls send me your query after masking the logon credentials!

Julio,

Have you tried something like this...

Update  DatabaseA.dbo.tableA A

SET  A.col1 = B.col1

FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=YourServer;UID=username;PWD=urpwd', DatabaseB.dbo.TableB) AS B

WHERE A.col2 = B.col2

Can you try this out...and lemme know if it...

If you have access to both these tables then all you need to do is run a query ...something like this

Update db1.dbo.table1 A

Set col1 = B.col1

From...

I think that is exactly what this will return ....But it will take each login attempt as an user.

Cheers!

Ooops ....Sorry abt that!!

I understand what you are looking for here is something like

Average logged in Time : x Hrs xx Mins  Max logged in Time: x Hrs xx Mins

for all users/sessions...

I understand what you are looking for here is something like

Average logged in Time : x Hrs xx Mins  Max logged in Time: x Hrs xx Mins

for all users/sessions...

If its on the same server then all you need to do is fully Qualify the table name with the database name.owner name.table name.

If the table is on a different...

I understand what you are saying...and yes you can also use case like how WINASH has shown above...but my query

WHERE ((@var1 IS NULL AND LastName = LastName)...

Thats cool Brian! Didnt know that cud be done.

Cheers!