Nov 09 2016

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

...and it is incredibly fast...it runs in less than a second against my several hundred thousand data set. Genius.
Nov 09 2016

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

...and it is incredibly fast...it runs in less than a second against my several hundred thousand data set. Genius.
Nov 09 2016

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

Wow...this totally worked! I love the simplicity. No need to avoid holidays so I am giving you the answer.
Nov 09 2016

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

Wow...this totally worked! I love the simplicity. No need to avoid holidays so I am giving you the answer.
Nov 09 2016

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

Wow...this totally worked! I love the simplicity. No need to avoid holidays so I am giving you the answer.
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 I see your point.
Nov 08 2016

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

@Hogan I see your point.
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?