SQL Server upgrade from SQL 2008 SP3
Hello all, I know that SQL 2008 R2 with SP3 has already been retired. We actually still have a system running it and with Windows Server 2008 R2. I am going to do the "upgrade" by using the Migrate to a new server approach. The old SQL server is with the DB storage inside this Virtual Machine. My idea is to keep this old DB as safe as possible. So I am going to backup this server with using Snapshot, as this old server is the VM. Then I planned to prepare build a new OS server with the new SQL server. My idea is to set up like that - Original stage Win OS SQL ver 2008 R2 SP1 2008 R2 SP3 Interim stage 2019 Datacentre 2017 Final stage 2022 2022
Have issue on fiscal week
Hi all, I am having below codes, but it was showing incorrectly for the year when previous year is having 53 weeks. Scenario: I am computing Fiscal Week, where ISO Week starts in July, first Monday in July with complete 7 days will be Week 1, then must have 7 days every week. Could you help me to solve the error part here? (Period 2020-07-01 till 2021-07-04) Expected outcome: 2020-07-01 till 2020-07-5 should be 202053 and the weeks after should be one week earlier. Code: CONCAT( CASE WHEN RIGHT('0' + CAST( CASE WHEN MONTH([DATE]) < 7 THEN DATEPART(ISO_WEEK, [DATE]) + 26 WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) = 01 THEN DATEPART(ISO_WEEK, [DATE]) + 26 WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) <> 01 THEN DATEPART(ISO_WEEK, [DATE]) - 26 ELSE DATEPART(ISO_WEEK, [DATE]) - 26 END AS VARCHAR(2) ) , 2) = '00' THEN YEAR(DATEADD(MONTH, 6, [DATE])) - 1 -- Subtract 1 from the year if FY_WEEK ends with "00" ELSE YEAR(DATEADD(MONTH, 6, [DATE])) END, RIGHT('0' + CASE WHEN MONTH([DATE]) < 7 AND DATEPART(ISO_WEEK, [DATE]) = 53 AND DATEPART(DAY, DATEADD(WEEK, 1, [DATE])) <= 7 THEN '01' -- Week 52 or 53 WHEN MONTH([DATE]) < 7 AND DATEPART(ISO_WEEK, [DATE]) = 52 AND DATEPART(DAY, DATEADD(WEEK, 1, [DATE])) <= 7 THEN '01' -- Week 52 or 53 WHEN MONTH([DATE]) = 7 AND DATEPART(ISO_WEEK, [DATE]) = 27 AND DATEPART(DAY, DATEADD(WEEK, 1, [DATE])) <= 7 THEN '01' WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) - 26 = 53 AND DATEPART(DAY, DATEADD(WEEK, 1, [DATE])) <= 7 THEN '01' -- Week 52 or 53 in new FY WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) - 26 = 52 AND DATEPART(DAY, DATEADD(WEEK, 1, [DATE])) <= 7 THEN '01' -- Week 52 or 53 in new FY WHEN RIGHT('0' + CAST( CASE WHEN MONTH([DATE]) < 7 THEN DATEPART(ISO_WEEK, [DATE]) + 26 WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) = 01 THEN DATEPART(ISO_WEEK, [DATE]) + 26 WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) <> 01 THEN DATEPART(ISO_WEEK, [DATE]) - 26 ELSE DATEPART(ISO_WEEK, [DATE]) - 26 END AS VARCHAR(2) ) , 2) = '00' THEN '52' -- Set to Week 52 if the calculated value ends with "00" ELSE RIGHT('0' + CAST( CASE WHEN MONTH([DATE]) < 7 THEN DATEPART(ISO_WEEK, [DATE]) + 26 WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) = 01 THEN DATEPART(ISO_WEEK, [DATE]) + 26 WHEN MONTH([DATE]) >= 7 AND DATEPART(ISO_WEEK, [DATE]) <> 01 THEN DATEPART(ISO_WEEK, [DATE]) - 26 ELSE DATEPART(ISO_WEEK, [DATE]) - 26 END AS VARCHAR(2) ) , 2) END , 2) ) AS FY_WEEK,Microsoft SQL Server 2017 Web Edition & Reporting Services 2017 Developer Edition error
Dear Community, I've setup a Microsoft SQL Server 2017 Web Edition and downloaded afterwards the Reporting Services 2017, because its no longer included in SQL Installation directly. During the setup of the Reporting Service 2017 Installation I had to choose the Edition and my choice was also there "Developer Edition". Now when I try to configure the Reporting Service I run into the following error message: "The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services." I added a print screen with the details. Does someone knows something about this error under Microsoft SQL Server 2017? Looking forward to every useful hint or input. Thanks and kind regards, Joël
