I would think the old, trusty MAX() would be clearer and less overhead than the mirrored function:

DELETE FROM tn

FROM dbo.tablename tn

INNER JOIN (

SELECT location, MAX(bookid) AS...

Yes, if you can, it would be much better to store from and to currencies as separate columns.

But, either way, you don't need to store 2 conversion rates, only one,...

--If the final total will be <= 24 hrs, you can do this:

SELECT CONVERT(char(5), DATEADD(MINUTE, DATEDIFF(MINUTE, STUFF(STUFF(date_column1, 9, 0, ' '), 12, 0, ':'), STUFF(STUFF(date_column2, 9, 0, ' '), 12,...

One or more them could also be exception/override tables. They may be empty in your case because currently you don't have any exceptions to normal processing rules/conditions. But...

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...