They do run under the same permissions as the user that caused them to fire (by whatever means).

I guess I'm not getting what you want to have happen. You...

Do you have an order for them, or just pick which one is record 13 at random?

You could insert into a temp table, with an Identity column, and select the...

What's the definition for the "item_key" column, since that's different in the two, while the other columns, other than hours, are all the same. If that column doesn't matter,...

Do you have any particular way of deciding which five to keep if there are six or more? Or just pick randomly?

One way to do this kind of thing...

Generally speaking, SQL chains permissions. If you have permission to insert into the main table, then it assumes (quite logically), that you have permission to perform all actions that...

Is there a reason to not just include the query in the proc? Procs can call other queries.

I don't think you want the sa password in a config file. That's got "we want to be hacked" written all over it.

That said, you should be able to...

Another important difference is that procs can modify data, while UDFs can't.

On-topic, I have to say, I think it should be up to the MVPs to decide whether or not to add something to their avatar and/or sig, rather than forcing...

I have to add, on the subject of "=" having two purposes instead of just one, I really love reading complaints about "overloading operators". The phrase itself defeats the...

Good article, good interview.

The best trick I've ever found for time management and efficiency is: If you pick something up, finish it, and do it right. The single biggest waste of time...

"GO" is a batch separator. It simply tells Management Studio to run these things separately, instead of as a single script. You can change to something else if...

duh duh duh - duh duh duh duh duh duh ...

Hmmmmm ....

Just doesn't seem to work that way.

Here, this'll be better! (Attached)

You won't be able to store that in date format, unless you assign it a specific date. Since you don't want to do that, your best bet is to...