Free for PREMIUM members
[Webinar] Streamline your web hosting managementRegister Today
select to_char(add_months(sysdate, -12 * (level - 1)), 'yyyy')
connect by level <= 11;
Open in new window
With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.
WHERE YEAR(DateColumn) BETWEEN 2003 AND YEAR(GETDATE())
Select * from YourTable Where YEAR(yourdate)> 2003 and YEAR(yourdate)<=YEAR(GETDATE())
CREATE PROC year_list AS
CREATE TABLE #years (year_number int)
Declare @yr int = 2003
WHILE @yr <= YEAR(GETDATE())
INSERT INTO #years (year_number) VALUES(@yr)
SET @yr = @yr + 1
-- RETURN SET
SELECT year_number FROM #years
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.