wolfkillj (7/7/2014)

---

Sean Lange (7/2/2014)

---

Stefan Krzywicki (7/2/2014)

---

Sean Lange (7/2/2014)

---

Stefan Krzywicki (7/2/2014)

---

Koen Verbeeck (7/2/2014)

---

It was...

It might be more logical if we change some words in the question:

What are the differences generated by update statistics on an execution plan in sql server?

Answer: It depends....

david.holley (7/7/2014)

---

Jeff Moden (7/7/2014)

---

jfogel (7/7/2014)

---

Great, just great. A year ago I wrote something that has to break down a CSV-style parameter string and it uses a loop to do it....

You can report spam :sick:

I'm not...

Most people make their first post asking for help with zero points. That would be restricting the help too much. Adding complication to the creation of new accounts to prove...

The solution that I posted? It will work on most RDBMS including Oracle.

You don't need a different tally table for each procedure. You only need one and you'll just determine the range when you query it.

You could as well create a view...

So, based on your posted data. What's the result that you're expecting?

I'm not sure that you need a function.

Here's an example using the over clause to solve the problem and at the same time the iTVF option. I strongly suggest you...

Can you post the code for R_35A and R_35B functions? This sounds like it will generate a terrible bottleneck. Could you post as well an example on how do you...

Evil Kraig F (7/3/2014)

---

winston Smith (7/3/2014)

---

dan-572483 (7/3/2014)

---

Of course if you're a good DBA, not only will put out the fires, you will put processes in place to prevent fires from...

Those are independent clauses.

You could work more to give the correct order.

SELECT empid

FROM consumer

WHERE empid in (2323,1236,5623)

ORDER BY CASE WHEN empid = 2323 THEN 1

...

I'm not sure where to start. Your variable assignment is completely wrong.

In other order of ideas, you could change your scalar function into an inline table valued function which should...

Yes, even if you have highly qualified professionals helping on this site, sometimes...

I'm giving a completely different approach here.

If you insert a pivot table in excel, you can connect directly to the table and pivot any way you want. Being a pivot...