And that is why I help out... I end up learning more, and it has the benefit of enforcing what I do...

SW_Lindsay (4/20/2010)

---

Nice and helpful article - Thanks. Just Curious...

To select eligible candidates in the first select you say

select * from @Candidates where MeetsEligibility = convert(bit,1);

Why do you convert...

Toreador (4/20/2010)

---

"SQL Server does not have an efficient way to retrieve rows based on a known value for PersonID."

There have obviously been too many trick questions lately, as I thought...

jeremy williams-435563 (4/19/2010)

---

Hi all !, i am trying to compare four columns in two tables(both are in the same schema), table a has two columns for firstname and last name...

Jeff Moden (4/19/2010)

---

Good. Because of my inherent distrust in all the other certifications, I'd like to see this one materialize provided that less fortunate folks can actually afford to...

Fire it my way. PM me if...

Jeff Moden (4/17/2010)

---

Heh... I finally beat someone...

cjohn5552 (4/19/2010)

---

Hey all,

So, I have a list of people whose names I want to query the database for. I get the IDs from an Excel spreadsheet, paste it into Notepad++,...

Paul - another excellent article on using APPLY. Thank you so much for doing this... now I need to find the time to disect these two articles, and get a...

You're talking about the blood-n-gore one?

Michael H Lutz (4/17/2010)

---

Great article. There is one thing I see though that is incorrect, the statement " This means that the execution plan for table variables will always...

Grant Fritchey (4/17/2010)

---

WayneS (4/17/2010)

---

Steve, surely...

That's what I'm talking about!

So, what the goal? 0:30? 0:15?

(41+...

Steve, surely you've seen me...

lmu92 (4/16/2010)

---

gregory.anderson (4/16/2010)

---

Lutz, before I read your last post, I updated the Update statement for the previous permits, this will do the successful inserts, as well as the failed inserts...