Try this:

ROUND(478.0/15, 0)

Your example is performing integer division, whereas you want to perform float division and then round.

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.