Nov 08 2016

Comment by Seth Spearman on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@Shnugo...my actual table has 367K rows.
Nov 08 2016

Comment by on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@Shnugo...my actual table has 367K rows.
Nov 08 2016

Comment by Seth Spearman on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@Shnugo. That is fine. In fact, I can add 500 rows of data. Is that too many rows? Is there a limit to how long the setup can be?
Nov 08 2016

Comment by on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@Shnugo. That is fine. In fact, I can add 500 rows of data. Is that too many rows? Is there a limit to how long the setup can be?
Nov 08 2016

Comment by Seth Spearman on Is there a way to aggregate a variable range of dates in SQL using a SET operation

Weekends or holidays don't matter. My ACTUAL application is in healthcare but wanted to choose something more generic than what I need.
Nov 08 2016

Comment by on Is there a way to aggregate a variable range of dates in SQL using a SET operation

Weekends or holidays don't matter. My ACTUAL application is in healthcare but wanted to choose something more generic than what I need.
Nov 08 2016

Comment by Seth Spearman on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@DForck42 I did do SOME research. Please know that I am not a SQL newbie. I write SQL every day and I love it. But I am not an expert. Having read my question, you think I could have googled my way to the answer? You think it is a simple question? It used to be that you could do your "research" by asking your question on SO. I guess I am behind on the meta. BTW, I understand how bad questions makes SO less useful and there is a problem to solve. I am just astonished that this question is considered a bad question.
Nov 08 2016

Comment by on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@DForck42 I did do SOME research. Please know that I am not a SQL newbie. I write SQL every day and I love it. But I am not an expert. Having read my question, you think I could have googled my way to the answer? You think it is a simple question? It used to be that you could do your "research" by asking your question on SO. I guess I am behind on the meta. BTW, I understand how bad questions makes SO less useful and there is a problem to solve. I am just astonished that this question is considered a bad question.
Nov 08 2016

Comment by on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@DForck42 I did do SOME research. Please know that I am not a SQL newbie. I write SQL every day and I love it. But I am not an expert. Having read my question, you think I could have googled my way to the answer? You think it is a simple question? It used to be that you could do your "research" by asking your question on SO. I guess I am behind on the meta. BTW, I understand how bad questions makes SO less useful and there is a problem to solve. I am just astonished that this question is considered a bad question.
Nov 08 2016

Comment by Seth Spearman on Is there a way to aggregate a variable range of dates in SQL using a SET operation

@Hogan ... what if someone doesn't know enough to try and do something. They lack experience or even a knowledge of what they don't know. Are they no longer welcome on stackoverflow? Are somewhat open-ended questions no longer welcome on SO? So if I had said something something like "I used this cte or this partition clause" is better than "deferring to the experts". I am astounded that this question is considered a bad question. SO will become irrelevant and get superseded unless it loses the judgmental-ism.