Ah, you're right.

Didn't read the thread carefully enough.

btw, the convert/cast difference is only because I copied mine from an old note made back when cast wasn't yet available in SQL...

Here's an old note I found in my archives.

Hope it may be of some help.

The general rule to use rand to generate random numbers from {lower limit} to {upper limit}...

The most common reason for this kind of error, is when your database has a collation that is different from the server's default collation, and the query generates tempdb activity.

In...

The basic syntax is:

INSERT myTable EXEC someProcedure

'sp_spaceused myTableName' returns a single resultset, so just create a table matching the output, and then use the INSERT EXEC syntax.

'sp_spaceused' alone otoh returns...

This is really another subject, but I feel I have to disagree anyway.

What you're essentially proposing here, is that the model doesn't count.

Whenever you're using 'select *' instead of an...

Sorry for the late reply, but yes, that's precisely what I ment. 🙂

/ 60 for the full hour, and % 60 if you want the remaining minutes

/Kenneth

So that means that the quantity column isn't correctly typed then, since the number of minutes doesn't have any fractions..

Still, divide the minutes by 60 and mod by 60 for...

If you have minutes, then divide by 60 for the hours and mod 60 for the minutes left on the remaining hour... Though, what does your minutes look like with...

This looks like a legacy join syntax..

But as Steveb says, don't use leagacy joinsyntax, start using ANSI joins instead.

It seems that what you're after is an outer join in this...

Any particular reason not to use any of:

sp_help_job

sp_help_jobactivity

..?

/Kenneth

So what is the real question?

Your SAN guys haven't zoned enogh disk for your server?

Have them expand it if it's full/too small.

/Kenneth

If I read your question right, the only difference is that one is case sensitive, and the other insensitive?

Implications are pretty obvious, if you're going from CS -> CI

CS 'a'...

Or, forget about MAPI and use Gert's xp_smtp instead.

http://sqldev.net/xp/xpsmtp.htm

Used it for years while on 2000 - never had any problems with it..

/Kenneth

It seems like the scope is increasing from the original problem..?

If you're starting to need exceptions in the dates based on 'non-calendar' attributes, such as workdays (next thing is perhaps...

Ah, you're absolutely correct.

That's what you get when you don't read close enough.. 😉

/Kenneth