Try this:

select number

from dbo.Numbers

where number between 1 and 10

order by floor((number+1)/2.0), number%2, number;

I love the first reply. Was that a bot, Steve? I've seen those exact words on a bunch of old posts, but this time, they're pretty entertaining. (What...

Daily activities are only part of it. The list above is pretty good for those.

You'll also want a schedule of weekly activities, and monthly, most likely.

For example, every Monday,...

Try this:

declare @Date1 datetime, @Date2 datetime;

select @Date1 = '11/1/1987', @Date2 = '12/15/1988';

select

(cast(convert(char(8), @Date2, 112) as int) - cast(convert(char(8), @Date1, 112) as int))/10000 as Years,

datediff(month, @Date1, @Date2)%12 as Months,

datediff(day, @Date1,...

Lynn Pettis (3/26/2009)

---

It also makes me wonder what company he works for as well. Must not have much in the way of data or they'd probably be complaining about...

Backup to USB HDDs is pretty good physical alternative to tape. They do take up a bit more shelf space, and cost more.

If you can safely assume that the next highest ID is also the next date, those methods will work. If that's not necessarily true, you can't count on them....

There is an option for tracing what computer the command came from. Look at the full list of columns available, and you'll find it on there.

Is the file having to grow in order to get the load done? That's the most likely cause of the slow-down.

I may be missing something. It doesn't look like you have end time in the table anywhere, so it seems to me that what you mean is that the...

One advantage for tape is it's a proven technology at this point. The flaws in it are well known, and pretty easy to compensate for.

The problem with "it depends" is that some people end up "stuck in a maybe", which results in nothing happening at all. Quite often, it's better to decide something...

The only time I've seen that happen was when the .NET app was accidentally calling the proc multiple times. Either the "Submit" button (or its equivalent) was being clicked...

I'm seeing that all over the forums from yesterday. The site may have been having problems.

If there can be more than one productRef, what you'll want is one XML query that uses nodes on that, and another one that uses nodes on the temps, and...