Lynn Pettis (6/3/2016)

---

ZZartin (6/3/2016)

---

Lynn Pettis (6/3/2016)

---

Steve Jones - SSC Editor (6/3/2016)

---

We can be pedantic if we want. However, a batch consists of 1 or more statements. The option notes that...

Lynn Pettis (6/3/2016)

---

Steve Jones - SSC Editor (6/3/2016)

---

We can be pedantic if we want. However, a batch consists of 1 or more statements. The option notes that the previous statement...

Terje Hermanseter (6/3/2016)

---

Too much old...

dietztm (6/2/2016)

---

Matt Miller (#4) (6/2/2016)

---

tindog (6/2/2016)

---

umailedit (6/1/2016)

---

Matt Miller (#4) (6/1/2016)If the two candidates were close (i.e. the rating for both was fairly close) it may be hard to quantify why...

Pizza

Those two formulas are not equivalent. Without looking at the data or taking into account date ranges this looks like what your query is doing.

SELECT (SUM(COL_ONE) - SUM(COL_TWO)) /...

Tobaccy

Dennis Q Miller (6/1/2016)

---

Stacey Decker (10/30/2014)

---

I agree, why allow two values to mean the same thing? I handle this by allowing optional fields such as AddressLine2 to be NULL and...

GSquared (5/31/2016)

---

David.Poole (5/27/2016)

---

If you turn up to an interview as Britain's worst presented compost heap then more fool you. You don't know who you are going to meet, whether...

Brandie Tarvin (5/27/2016)

---

I just heard from my husband (who works at Deutsche Bank) that there is a holiday coincidence for Monday. A confluence of several countries having bank holidays at...

Making biased assumptions based on past experience or anecdotal evidence is part of human nature, drawing biased conclusions and being unwilling to change them when they prove false on the...

Hopefully you have a dev and test environment you can test this in first. That's where any major issues should shake out.

But the most important things are to check...

Silver

This might work,

DECLARE @myvalue INT

SELECT @myvalue = MAX(COL_ONE)

FROM (SELECT DENSE_RANK() OVER(ORDER BY TotalSalesAmt) COL_ONE FROM SalesItem2) TEMP_ONE

Is this a phone interview with an HR recruiter type person or a more technical person? Either way your main goal on a phone interview should mostly be to...