Synonyms. It has problems, but less than the other options. I've tested this kind of thing, and synonyms worked best in my tests.

Sean Lange (8/18/2011)

---

You can't create a database and reference it in the same stored procedure. You can only use a single batch within a stored procedure and your database will...

I don't bother with xp_cmdshell these days, because I can't think of anything I can do with it that can't be done better with CLR or SSIS. It's not...

TBM, you're misreading the question. Price isn't part of the Where clause. E is correct. Unless the typo in the query is in the original quesition, in...

ALZDBA (8/17/2011)

---

Evil Kraig F (8/17/2011)

---

Anyone interested in helping someone out architecting a nasty little schema design in Access, can you give this fellow a hand here: http://www.sqlservercentral.com/Forums/Topic1160273-373-1.aspx

Seems like a nice...

Good idea!

PS: Most of them aren't certifications, and the ones that are, have nothing to do with databases or even computers. They're all applicable abbreviations, but it's meant to...

Clearing the cache tests how well it runs if it hasn't been cached. Most of the time, on most servers, the more usual user experience will be with it...

As a caveat, if you enable xp_cmdshell, make sure you understand all the security implications of it. All of them. It's a good way to end up with...

Run each multiple times, with I/O and time stats turned on each time. You'll see compile time vs run time when you do that. You need to know...

All steps for both:

1) Get budgetting from Finance for a contractor

2) Get with HR to get a competent contractor

3) Let the contractor do it

4) Pay the contractor

5) Go out to...

Chris, I think he's probably using some variation of a Calendar Table. Those are the best way to calculate things like working days and such, and it looks like...

Is it possible it's in a chart or data matrix region of the report? If so, MSDN says it won't work.

Is it already running maybe?

You'd have to use xp_cmdshell, so far as I know, to do that from an SQL script. Why not just run it more directly, with PowerShell, or whatever your...

Add in a Where clause that only selects dates that are prior to the current day?

Without the structure and sample data for your UserInfo table (which is what it looks...