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.
SELECT d.ndocument, d.udf1, d.created,d.taxyear,t1.Name,t1.Parent,t1.Policy, t1.value,d.expirdate ,cast(D.taxyear as int) + 8 AS NewTaxYear, CONVERT(VARCHAR,( convert(varchar, cast(d.taxyear as int) + 8)) +'-'+'12'+'-'+'31', 101) as updatevalue FROM Documents d inner join ( SELECT CASE WHEN CHARINDEX('!', l.value) > 0 THEN LEFT(value, CHARINDEX('!', value)-1) ELSE value END as value, name, Parent, CASE WHEN value LIKE '%!%' THEN RIGHT(value,CHARINDEX('!',REVERSE(value))-1) END as Policy FROM [Cadoc_Ext].[dbo].[lookupexport] l )t1 on d.udf1 = t1.value where Policy = 8 and year(d.expirdate) != '9999'