Actually, I was thinking about it, and what you want to do is this:

SELECT @strSql = N'SELECT @strFunctionResult = ' + @strRuleFunction +

...

sp_ExecuteSQL is the right way to do what you're trying to do. Since the string itself doesn't change (only the parameters), it should not regenerate query plans. It...

I just ran through and tried it, and it appears that the master database can not be used for a publication. I am not surprised.

It looks like scripting is...

I definitely don't want to use cross-database synonyms. I want to use copies of those functions, but I don't want to have to create the copies myself. I'm...

I actually did a lot of hiring in the past. It was at a fast-food restaurant, but I still learned a lot about people. I asked a host...

James Stover (7/2/2010)

---

Dan.Humphries (7/2/2010)

---

If you where a box of crayons what color would you be and why?

I love when these types of questions get asked!

Can someone tell me how...

michael.wiles (7/2/2010)

---

Grant Fritchey,

You alluded to the fact that you look at work history with applicable knowledge in order to give someone a position. How does someone usually get work...

I've found that people who take the time to learn the stuff on their own usually have more enthusiasm and ambition when it comes to working with the technology. ...

Being a developer is a very dynamic job. You may begin working on one platform, and end up somewhere completely different. Over the course of just a few...

Using Excel and CSV files as a permanent data store is ill-advised. Using Excel or CSV for data entry is even worse. The fact that you need to...

You only need another table if you have a many-to-many relationship. Order header to order lines is a one-to-many relationship, so you need only store the primary key of...

I want to thank everyone again for all their advice.

I did end up getting what I was after late last week. As frustrated as I was (still am a...

I have never used schemas for security (I agree that security is easy enough to set up without schemas, and I've never had a need). Instead, I use it...

WayneS (6/22/2010)

---

Maybe what is needed is to utilize a method that will allow you to programatically test all the permetations of a procedure. By saving this test, you will be...

I definitely make no claims towards perfection. In fact, I regularly set the expectation that programs fail, bugs happen, and things happen which aren't exactly predictable. My goal...