Yes - I would advise you to amend the other procedures to deal with this.

The only reason I can think of as to why they seem to work already is...

Then SQLBill's post is 100% relevant.

Have a look here:

http://www.sqlservercentral.com/scripts/contributions/1545.asp

Do you mean a script to insert data?

You just need to add an additional WHERE condition to your queries.

Query 1 - >

SELECT DrawID,DrawDate,WinningNumbers FROM [Result Table] WHERE

 DrawID IN (SELECT Max(DRAWID) From [Result Table] where...

That is somewhat clearer, though I am still a bit puzzled about how you are prepared to wipe all of the data that exists in some of the tables in...

I must be missing something, but here's how I would answer questions (1) and (2)

1)  select * from projects where '2006-03-01 00:00' between StartDate and EndDate

2) select * from projects...

To get those results, what did you put in @StartDate and @EndDate?  Was it 1/8/2005?

I presume that you are not capturing the changes themselves - you just know what tables are affected and want to send those to your 'live' server?  This sounds a...

OK - we're going to have to go into a bit more detail then.  Can you please post examples of the query that you are using, the source data, the expected...

But the left() function returns a varchar, not a datetime, so there's something strange going on here

Perhaps your problem is linked to the...

It seems that you are not sure of the root of the problem - is it VB, or is it SQL Server?  I suggest that you run Profiler to see...

So can you write the SELECT query for the unrelated table separately?  Eg something like this:

select CMclientName

from SCHOOLNET.dbo.clientmaster

WHERE CMclientName = 'whatever'

If you can,...

Can you use WAITFOR?  Check BOL for more details.

In Enterprise Manager, expand Management, right click on SQL Server Agent and select properties.  You'll be able to change the logon properties for the SQL Server Agent service there.