DarthBurrito (12/7/2012)

---

Let me add that I'm using this SP for a SSRS report. As the code I provided stands, the SP has one parameter called Products. So the parameter accepts...

Jeff Moden (12/6/2012)

---

patrickmcginnis59 (12/6/2012)

---

Jeff Moden (12/6/2012)

---

patrickmcginnis59 (12/6/2012)

---

Jeff Moden (12/4/2012)

---

So far as no offer being extended, that's fine because I don't want to work for a company that wants a code...

Jeff Moden (12/5/2012)

---

ScottPletcher (12/5/2012)

---

Jeff Moden (12/4/2012)

---

ScottPletcher (12/4/2012)

---

It would take far longer than 2 minutes to give the full background you wanted.

This for a simple, introductory interview q, when I often...

Yeah, the 10% is awful. I'm afraid I don't see the point of resetting to something almost as bad.

Why not create default growth tables based on total size, one...

Jeff Moden (12/4/2012)

---

ScottPletcher (12/4/2012)

---

It would take far longer than 2 minutes to give the full background you wanted.

This for a simple, introductory interview q, when I often had two more...

Excellent point, and quite correct (I just...

Jeff Moden (12/4/2012)

---

ScottPletcher (12/3/2012)

---

Jeff Moden (12/3/2012)

---

If I were in an interview and someone asked me such a question, my answer would be that future requirements could easily change, especially in...

Jeff Moden (12/3/2012)

---

If I were in an interview and someone asked me such a question, my answer would be that future requirements could easily change, especially in the area of...

SELECT

GrpID, GrpName,

ISNULL(NULLIF(MAX(CASE WHEN Spc <> 'Mixed' THEN Spc ELSE '' END), ''), 'Mixed') AS Spc

FROM #mytable

GROUP BY

GrpID, GrpName

HAVING

MAX(CASE WHEN Spc = 'Mixed' AND PrvName =...

Hmm, something seems odd.

SQL should be able to easily do "simple parameterization" -- the old name, "auto-parameterization", seems clearer to me -- on that query. That is, SQL should...

What was the status of the log file when you ran the command? How large was the log, how much space was free, and what was the Autogrowth amount?

Be...

Or,...

Seriously, test_nbr limited to 3? What about previous classes? And classes for the next semester? Test_nbr would be identifier,...

Jeff Moden (11/30/2012)

---

ScottPletcher (11/30/2012)

---

Jeff Moden (11/30/2012)

---

ScottPletcher (11/30/2012)

---

Jeff Moden (11/29/2012)

---

That's a good test question, Scott. The only thing I might change is requiring them to do it "in a single...

CELKO (12/1/2012)

---

I use this query as extra credit for my students when I teach a SQL class. ... This is much trickier than it sounds at first....