After adding another possibility, I found...

I don't get any error, I'm not sure if I was supposed to get one.

Here's my test along with alternative methods.

WITH SampleData AS(

SELECT 'Luis Cazares' AS...

Have you considered using a calendar table to join with the date ranges and use COUNT() grouping by account, location and month? Do you need an example?

To get dynamic calculations on dates, you can use the DATEADD() function.

Remember that when using BETWEEN, the lower value goes first or you'll get a non-valid range with no error...

That's good to know. As I'm basically a developer, I'm not used to work on admin tasks.

Thank you, Lowell.

pharmkittie (1/29/2015)

---

Luis Cazares: Hey, we all have to start somewhere. What would you suggest as the better way? Thanks.

dwain.c and mister magoo: Thank you! I will try...

asm1212 (1/30/2015)

---

Luis, or someone else, I am a fellow DBA but I have not seen this before! If it is not too much to ask, can you just kind of...

Are you seriously creating the same stored procedures for each quarter? I don't want to imagine what would happen if you need a daily report.

Just to give both options together to compare them. The first version including all the remainder in the first month and the second version putting an extra cent per month.

ALTER...

Maybe something like this. If you change/remove the third parameter of round() you'll get different results. This will always return the first payment equal or greater than all the other...

That's totally understandable, don't worry.

SpeedSkaterFan (1/29/2015)

---

Anyway: the results of your code looks to be exactly...

Tweaking Alan's code, I can reduce the reads by half by reducing the length of the code. 🙂

WITH uqvals AS

(

SELECT ID,

MIN(DateOpen) DateOpen,

...

This article will help you to obtain the desired result.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

It's because your varchar column is being implicitly converted to a numeric(4,0) as stated on the data type precedences. SQL Server does implicit conversions because it can't compare apples with...

I'm not sure that I understand the second parameter. This is what I've made.

Note that I changed the scalar function into an InLine Table-valued function. To know why, read the...