Data may or may not overlap.

HI Phil,

Thanks i have slightly changed it as it was not coming for Month 3, but where i am getting two more additional rows which is not the use case.

Hi Jeff,

Sorry to get back you after long time.

Is there possible to get next week data as well. Since this needs to be prolonged until last week of current date.

Reference table is the place where the actual file name was. Initially it has only one file for each table, so we have a reference table and ensured that we...

Sure I will correct from next by typing the content here and code in code area.

Hi Jeff -I am using third party component which will connect to another third part...

Thanks.

But I am using Merge statement as there are new records and modified records in the same file, so I need to insert or update accordingly, is there any alternate...

Any suggestions or reference please ?

Ref table is something we get it predefined , where as master data is something we will be getting with some extra data sometime.

But now i think i had done.

Hi ,

First would like to Thank Steve Collins for his time and effort on achieving this.

How to achieve the same with Archive records as well along with the current table...

• This reply was modified 2 years, 4 months ago by  LearnSQL.
• This reply was modified 2 years, 4 months ago by  LearnSQL.

Steve ,

As you have created the dbo.CalendarByDateFirstRefactored function in other thread, will you be able to resolve my issue.

Thanks a lot for your effort and time.

Thanks a lot Jeff for your wonderful work.

Any suggestions or thoughts.

declare @startdate datetime='2019-01-01'
declare @cnt int=1
while @cnt<2000
begin
declare @table table(date date, year int, quarter int, month int, monthName varchar(20),Weeknumber int, 
 dayweek int,Weekday Varchar(20),WeekStartDate date, WeekEndDate date, MonthStartDate date,...

• This reply was modified 2 years, 5 months ago by  LearnSQL.

Hi Jeff,

Thanks for helping me out here. Here is the calendar data.

I have tried different ways and now able to get some what close.

What has happened is that after 202152 it is going till 202200 not to 202201. how to achieve...