Is there a way to do that with the help of a T-SQL script or i have to manually do it one by one?

Just a little modification in above query and get the result :

SELECT CONVERT(VARCHAR(12),DATEADD(yy,-2,DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0)),101)

T-SQL program fetching the first character of each word in the given string :

DECLARE @STRING VARCHAR(8000);

DECLARE @Pos int =1;

DECLARE @FINALSTRING VARCHAR(8000) = '';

DECLARE @COUNTER int = 0;

DECLARE @DELIMINATOR VARCHAR(1) =...