Please post DDL (create table) for tables or declaration of table variables and inserts with sample data.

Like it.

Try:

SELECT Convert(varchar(10),Cast('20170609' AS date), 103) Char8AsUKdate


Try:

SELECT DISTINCT ID, u.ValueX
FROM (SELECT ID
     , MOD0
     , MOD1
     , MOD2
     , MOD3
     , MOD4
     , MOD5
     , MOD6
     , MOD7
     , MOD8
     , MOD9
     , MOD10
     , MOD11
    ...

This can be done using a stored procedure to update or create an update trigger.

DECLARE @tbl table(ID int, Val int, ValType varchar(20));
INSERT @tbl (ID, Val, ValType)
VALUES (1, 23, 'Location')
     , (2, 34, 'Location')    
     , (1, 44, 'Vehicles')
     , (2, 34, 'Vehicles')
    ...

Try:

DECLARE @test-2 table (ID int IDENTITY,CATEGORY VARCHAR(10));
INSERT @test-2 (CATEGORY)
VALUES ('5HW6')
      ,('256')
      ,('57')
      ,('3')
      ,('4578')
      ,('256HW');
SELECT ID
     , CATEGORY
FROM @test-2;
SELECT ID
     , n Position
     , Substring(t.CATEGORY, n, 1) Letter
FROM...

http://www.sqlservercentral.com/blogs/spaghettidba/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

create a table to store these statistics and create a job to run it daily.

I prefer to use stored procedures for DML and handle encryption/decryption in the procedures.

Try:

DECLARE @d datetime