vinothraj (12/17/2010)

---

I'm working in linked server but you might be working in your own. i just told it based upon the average of ten times but i would like to...

Have you asked why and can you share their thought pattern here? Just insisting doesn't mean it is correct. I would hope that they would be open to...

First, unless there are io system issues that prevent it, running backup of multiple databases simultaneously shouldn't be a problem.

Second, my suggestion really wasn't to run simultaneous backups, but backup...

???

I would have to say Service Broker as one. There is a lot one can do with it, and quite a bit of the necessay infrastructure is already built....

Not sure if this will fully meet your needs but it seems to fulfill your currently known requirements and should run under SQL Server 2000:

-- See how you start off...

Having been using GETDATE() since I started using SQL Server, that is what I use. However, now that I am using Oracle, I have to change my ways. ...

There is still a problem with my code based on your previous post. How would you correct my code? I have already identified the necessary fix.

Craig Farrell (12/16/2010)

---

The short form, if I had to make a guess without the code/samples, is that you're using a where clause to limit the results to your actual ints.

This...

Suggestion, instead of building your queries inside the apsx code, try encasulating the queries inside stored procedures or views and select from those. If the query has to change...

If you don't mind, I'd like to ask a question first. Why are you separating the date and time? I would think it would make more sense to...

Jeff,

Don't worry, mine doesn't fully work properly either. To make it work every time, you have to add enough 9's after the decimal point to fill the precision of...

Before giving you a sugestion, what was the actual (full) error message you received?

A suggestion, if possible, backup locally then move to a network location.

hoanglong88i (12/16/2010)

---

Thank Lynn but your solution still has problem. Now when Anna returned to the clinic on the other day, her status is New while it must be Return.

20 ...

Based on code above, please remember that round(value, length, 1) will truncate, not round.

Here is possibly another method, but not tested to the extremes.

/* Non-Integer Data */

SELECT

...