So essentially you're grouping islands together. (The island consists of consecutive months of data). Fancy that! I found an old Dwain Camps article! (I miss his posts... he...

Vedat, Sen bir dahisin, teşekkür ederim!

Thank you!  it worked.

In my results, I'm grouping by mydate on consecutive months.  So the first 3 rows are consecutive months but the next row is 05 which skips a month.  So i'm...

Scott, This is very helpful.  Thanks!

Scott,

How do I add the tablename to this query?  So it displays the tablename with the result of the max().

I'm also getting a'Concat_ws' is not a recognized built-in function name.

String_AGG will not work for me.  I just realized, I'm working on SQL 2016.

I think I will also need to add the table name to the result of the query.

Jeff, thanks for taking the time for that educated explanation.  I learned a lot from it.  I had to look up "corpuscles", for a moment I thought it was a...

I would define first week as any days of the month that land on the first week of the month.  i.e. if September 1 lands on Friday, then September...

• This reply was modified 1 year, 1 month ago by  GrassHopper.

I would define first week as any days of the month that land on the first week of the month.  i.e. if September 1 lands on Friday, then September 1...

worked great!  Thank you!

Jeff,  We have an existing table that houses this information for other years.  I was tasked with adding the dates for year 2021 to this existing table, but I didn't...

Yes, I have the fnTally function.  When I run your code the way it is, it errors "Invalid column name 'Number'

Sorry. His version uses "N". I modified my version...

Do you have Jeff's fnTally function and did you test it? It is a TVF that in this case returns numbers 1-52...

after I fixed the script to return Number +...