You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.
With xMatters, you'll never miss a beat.
UPDATE newseason SET YearNumber = left(@SeasonNumber,4), YearName = left(@SeasonNumber,4), SeasonNumber = @SeasonNumber, SeasonNumber1 = @SeasonNumber, SeasonName = @SeasonName, MonthNumber = left(@SeasonNumber,4) + '0' + left(CONVERT(CHAR(8),TID,10),2), MonthName = DATENAME(MONTH,TID) , WeekName = REPLACE(('Week of ' + left(CONVERT(CHAR(8),TID,10),2) + '/' + substring(CONVERT(CHAR(8),(SELECT DATEADD(wk, DATEDIFF(wk,0,TID), 0)),10),4,2) + '/' + cast(Year(TID) as varchar)),'Week of 0','Week of '), WeekNumber = cast(Year(TID) as varchar) + '00' + cast(DATEDIFF(week, @FiscalYear, TID-1) as varchar)+1, DayNumber = cast(Year(TID) as varchar) + '0' + cast(DATEDIFF(day, @FiscalYear, TID+1) as varchar), DayName = (SELECT DATENAME(dw, TID))
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.