LOL me neither.

Not at all. They are clearly so far over their heads they can't...

Eric M Russell (6/9/2016)

---

Sean Lange (6/9/2016)

---

Eric M Russell (6/9/2016)

---

patrickmcginnis59 10839 (6/9/2016)

---

Eric M Russell (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a...

Luis Cazares (6/9/2016)

---

patrickmcginnis59 10839 (6/9/2016)

---

I don't understand, if you don't care if its right, and additionally the applicant can apply zero thought to it and its still acceptable, whats the...

Eric M Russell (6/9/2016)

---

patrickmcginnis59 10839 (6/9/2016)

---

Eric M Russell (6/7/2016)

---

Luis Cazares (6/7/2016)

---

Was I too late for April fools' day?

This is what happens when you trust a forum to answer questions that...

Lynn Pettis (6/9/2016)

---

Looks like Sean does have the crystal ball...

Lynn Pettis (6/9/2016)

---

Sean Lange (6/9/2016)

---

This still is not really very clear what you are trying to do but here is my shot in the dark. You are looking for rows...

GSquared (6/9/2016)

---

Sean Lange (6/7/2016)

---

Jeff Moden (6/7/2016)

---

I think it's a great question. It shows whether or not...

This still is not really very clear what you are trying to do but here is my shot in the dark. You are looking for rows where BOTH ColA AND...

Lynn Pettis (6/8/2016)

---

Mention Dynamic SQL and suddenly that is THE solution for the immediate problem, but what problems may it cause down the road?

Won't be surprised if we hear from...

drew.allen (6/8/2016)

---

There is no need for dynamic SQL here. He's storing these values in a temporary table, and the values aren't going to change (in most cases) between when...

You will have to use dynamic sql if you want to get the values returned from those functions. As it is they are only string literals, as Lynn pointed out....

Lynn Pettis (6/8/2016)

---

Won't deny that, looks even weirder when you use the same variable name on each side. I have done...

I think yb751 has the right answer. However, maybe you should consider a better name than calling it RowNum. In this case maybe something like CodeNum would be better. It...

j-1064772 (6/8/2016)

---

Good day,

I am having difficulty understanding how to make available a parameter set with dynamic T-SQL.

I expect value of the [font="Courier New"]@s_MaxOrderOut[/font] to be already defined in the [font="Courier...