Luis Cazares (11/13/2015)

---

hoseam (11/13/2015)

---

Hi

I have a column that has values [1,2,3....10,11,13,14 ...]

I want to return just two characters, e.g [01, 02, 03....10,11,12...]

I concatenated a string before to

'0'||CAST(m.d_depend as varchar(2))...

This is certainly an interesting situation. In every drawing I've seen, 3 decimal places are the norm, but I've seen some go out to 4 places. With this...

Generally speaking, any time you have a function calculate something in the predicate of a WHERE clause, the predicate is called non-SARGable. It's because the filter can't be applied...

Steve Jones - SSC Editor (11/13/2015)

---

What do you mean by input and output? Are you trying to show the output of the query?

It's unclear what you've done with the data,...

Jeff Moden (11/13/2015)

---

This is actually pretty sickening. Why do you even bother going to school if you're not going to even try. You should drop the course if...

Eirikur Eiriksson (11/13/2015)

---

Sean Lange (11/13/2015)

---

Eirikur Eiriksson (11/13/2015)

---

Sean Lange (11/13/2015)

---

I will disagree slightly with Eirikur here. The values in ROW_NUMBER will always be the same but the order of rows in...

Sean Lange (11/13/2015)

---

Instead of a PIVOT I would recommend using a crosstab. The syntax is far less obtuse to me and it even has a slight performance benefit over PIVOT....

I absolutely use schemas and find them quite useful. I use them to separate different types of functionality. For example, the procedures that comprise the ETL portion of...

First of all, please tell us that all your columns in your join predicates are of the same data type. Implicit conversion can kill the performance of any query.

You...

Luis Cazares (11/13/2015)

---

BL0B_EATER (11/13/2015)

---

BrainDonor (11/13/2015)

---

I would just like to say, that I've always admired the people that are willing to publish articles on this site.

Now that I've faced the editor...

No matter what server-level permissions a user has, you should still use two-part naming conventions. It's just good practice and avoids the engine having to do the extra work...

Sandler

Yeah, I clicked AS...

Sean Lange (11/12/2015)

---

Jack Corbett (11/12/2015)

---

Sean Lange (11/12/2015)

---

Brandie Tarvin (11/12/2015)

---

Sean Lange (11/12/2015)

---

djj (11/12/2015)

---

Grant Fritchey (11/12/2015)

---

Still, could be fun. Build out a nested CTE inside a function, use the same...

BrainDonor (11/12/2015)

---

GilaMonster (11/12/2015)

---

You can also do things like

myname+sitename@<domain> (or maybe the other way around)....