majorbloodnock (8/13/2008)

---

Grant Fritchey (8/13/2008)

---

Jeff Moden (8/12/2008)

---

Now... if you can do that without spilling the Beer you're holding... 😉 The really good ones can do it while taking a sip...

Let me understand this...

The Historical_Propertys table has a pk, Property_ID. The Property_Managers table has a pk, Property_ID. There is a foreign key constraint on the Historical_Propertys table against the Property_Managers...

I'm a little confused. If you grant execute to a stored procedure that can insert data... it's going to insert data. The way around it is to not grant execute...

While I love VS for DB's and I'm even presenting a session at PASS on how to use it for multi-environment deployments, I don't think it will do what you're...

Well... It depends...

The IN clause in this case is probably going to cause a table scan. I'd say that you're better off using IF EXISTS in a nested fashion such...

Whether or not business logic should be inside a query is a HUGE debate. There are extremists on both sides. I'm pretty much in the middle. If it makes sense...

Can you post the scripts you're using to create the tables? There may be something there.

Jeff Moden (8/12/2008)

---

Now... if you can do that without spilling the Beer you're holding... 😉 The really good ones can do it while taking a sip without getting getting...

Good to know. Unfortunately, with the division of labor where I work, I don't have the ability to do that. But if I really need it, I know what to...

Too late. I ran up a silly example and posted...

riix (8/12/2008)

---

Grant you seem more stressed than Gail; the point of discussion was Gail earlier stmt:

"Just watch the performance implications. A single statement tvf is usually fine, the multi-statement ones...

I'm on the way home, I'll try to set up a test tomorrow. You can see a huge difference in only a few hundred rows. Multi-statement UDF's are just a...

Gail, I can tell you do softer style martial arts because your response is much more a redirect of his energies than mine would have been. Very nice.

riix, try this,...

The thing is, most people on the thread, just about everyone on the thread, that suggested using TSQL cursors was a bad thing didn't say "THOU SHALT NEVER USE A...

You can't do that in 2000.