Ed Wagner (2/7/2016)

---

You've already done most of the work. All you need is a query to run over the data you already have. I added a function to...

Here's one way you could do it:

WITH summed_and_ranked AS

(

SELECT d.state,

vs.modelID As Model,

sum(vs.totalSalesCount) As...

If you're not using RETURN to specify a return value for the stored procedure, when you successfully run EXEC @variable=stored_proc, you'll just get a 0 assigned to the variable.

You'll want...

drew.allen (2/5/2016)

---

Jacob Wilkins (2/4/2016)

---

drew.allen (2/4/2016)

---

Jacob Wilkins (2/4/2016)

---

Unary plus and negative: https://msdn.microsoft.com/en-us/library/ms174362.aspx

Cheers!

EDIT: I must say that it is still strange that the unary plus works with string data, since the documentation...

Very nice Orlando! I thought there might be something with LAG/LEAD that allowed a single scan of each table, and it looks like you found one.

I ran through some quick...

drew.allen (2/4/2016)

---

Jacob Wilkins (2/4/2016)

---

Unary plus and negative: https://msdn.microsoft.com/en-us/library/ms174362.aspx

Cheers!

EDIT: I must say that it is still strange that the unary plus works with string data, since the documentation specifies numeric data....

Unary plus and negative: https://msdn.microsoft.com/en-us/library/ms174362.aspx

Cheers!

EDIT: I must say that it is still strange that the unary plus works with string data, since the documentation specifies numeric data. However, it also...

Orlando Colamatteo (2/4/2016)

---

Jacob Wilkins (2/3/2016)

---

I think the code below does what you want, if I understand the requirements correctly. It scans each table twice, so if the source tables are...

I think the code below does what you want, if I understand the requirements correctly. It scans each table twice, so if the source tables are very large then this...

Check out http://sqlperformance.com/2012/08/t-sql-queries/median.

Just be aware that the dueling row numbers approach (2005_A in the article) does not guarantee the correct result if there are ties in the values used for...

Ah, that's what I was afraid of.

So it sounds like the values in some attributes are connected to specific values in other attributes. If there's a table somewhere that...

As much as I hate being a broken record (or beating dead horses), I'm still really confused as to the logic behind a LOB with two unique values for each...

I'm glad you found the resources you needed to understand the wait type.

Just keep in mind that when switching to asynchronous you're not just getting the same mirroring without the...

Hugo Kornelis (2/3/2016)

---

At first I had the server option selected as well.

Then I recalled that the connect option at server level is actually called CONNECT SQL, not just CONNECT, so...

In that case I'm still a bit confused, I fear.

Why do we want all combinations of distinct values with J Livingston's data (4 distinct values for one attribute, 2 for...