"Can anyone tell me why this Query will not return "ONLY" NULL data?"

What makes you think that this query might return only null data?  The only mention of null in...

You don't tell us what exactly you are trying to do:  insert records from a table, update records base on values.  The solution is probably very similar, but it is...

There are so many things to this.  I would probably take a day to put it together. I have done similar things in different projects, but not all in the order you...

You are going to need to use an ado.command object with a parameter of type output.  You will need to pass in a connection string (or hard code it).  Do...

What this discusses is getting the data into a global variable from the output parameter of a stored procedure. http://www.sqldts.com/234.aspx

From there you can refer to the global variable in...

Before I dig in, let me make sure I understand your problem.  I think that this can be done.

How do you get this file?  Is there a folder that contains...

Try this:

http://www.sqldts.com/234.aspx

If it is the database password, you need a different element try:

Database Password=MyDbPassword;

rather than pwd=MyDbPassword

This will also work:

Select s.EventID, Datediff(s,s.EventDatetime,e.EventDatetime)as seconds, s.MachineID, s.EventType,

case when

(Select emt.EventType from

(select Max(em.EventID) MaxEventID from  #GPSEvents em

where em.EventID <= s.EventID

  and EventType in (4,5)

  and em.MachineID = s.MachineID)...

I'm not clear what the columns and rows represent.  I think that a list of rows that exemplify what you are wanting (with columns labeled) with the expected output would...

I think that I understand what you are trying to do.

You need an activex script that reads one record from the recordset and sets up other tasks based on that...

I don't believe that there will be any blocking, but I can't be sure.  I believe that SQL Server will get row level locks and will let you insert. I...

I found the test to be somewhat challenging.  I have listened to a lot about SQL 2005 and have occasionally used the tools.  But I'm still working primarily in SQL...

Someone please correct me if I am wrong, but after trying to do what you stated, I was told that the Access database has to be on to server in...

Also, make sure that there is no maximum file size for the log file.