Can you post up some consumable sample data for the tables please?

In order to write the second query, you will need to know how to track a single commission amount...

In the absence of an Actual execution plan, any suggestions would be guesses. Can you post it please, as a .sqlplan attachment? Thanks.

You may find some useful info in this thread. Post back if you have more questions.

aaron.reese (11/5/2014)

---

I don't like the join of BOM

you are filtering the join based on properties of RO - these feel to me like they should be in the WHERE clause.

If...

;WITH SampleData (BASEDPTH, OWN, SEGLEN, SURFWID, UNITID, DESCRIPT, STKEY) AS (

SELECT 0, 'COF', 710.14, 30, 'YORKTOWNDR', 'YORKTOWN DR', 4774 UNION ALL

SELECT 0, 'COF', 349.23, 30, 'YORKTOWNDR', 'YORKTOWN DR', 4774 UNION...

jacksonandrew321 (10/31/2014)

---

I will take example of the below table

In this table I want to count records of column parcel2014 in between dates 2006 and 2016 then what should I fire...

How many rows in table #md?

What's the distribution of values in the columns BID & BWG?

Looking at Name "A", the second row (by Seq) is within 48 hours of the first row. The third row is within 48 hours of the second row. The fourth...

LEFT JOIN your data table to a calendar table.

vee_jess (10/28/2014)

---

Chris,

Your date function is very cleverly written. Is there a way to get a bigger dataset out of this function? I want a date to start from 01/01/2012 till...

DaveBoltman (10/28/2014)

---

CROSS APPLY has the advantage that the function is only called once for each possible value of the function parameters, rather than once for each row. Convert it to...

vee_jess (10/28/2014)

---

Hi Chris,

My apologies, I was confused when I didn't see data for Tuesday week 4 2014 and then there was data for Wednesday week 4 2014. The reason for...

I don't see an issue, the query outputs data for October, week 4 - can you...

vee_jess (10/27/2014)

---

Hi Chris,

After testing I have noticed that this query isn't working as expected. I'm getting 0 parcel count 2014 for Tuesday weekNo 4 in October, then there are parcel...

Sure, go for it Fred.