Monday 6 May 2019

Calculate number of months between two dates using javascript

var dtFrom= new Date('01/05/2019');
var dtTo= new Date('01/06/2021');

 var fromYear;
    var fromMonth = dtFrom.getMonth() + 1;
    var toYear;
    var toMonth = dtTo.getMonth() + 1;

    if ((fromYear = dtFrom.getFullYear()) < (toYear = dtTo.getFullYear())) {
        toMonth += (toYear - fromYear) * 12;
    }
    var diffMonths = toMonth - fromMonth;
    if (dtFrom.getDate() > dtTo.getDate()) diffMonths--;
   
-----------------------------------------------------------------------------
For get only the month diff

var dtFrom= new Date('01/05/2019');
var dtTo= new Date('01/06/2021');

 var monthCount = 0;
    while ((dtFrom.getMonth() + '' + dtFrom.getFullYear()) != (dtTo.getMonth() + '' + dtTo.getFullYear())) {
        monthCount++;
        dtFrom.setMonth(dtFrom.getMonth() + 1);
    }
    monthCount  = monthCount + 1;

Tuesday 23 April 2019

Remove special characters in a particular column

DECLARE @myString varchar(500), @validChars varchar(100)
SELECT @myString = 'sA123-\[]{}',@validChars = 'a-z0-9'

While @myString like '%[^' + @validChars + ']%'
Select @myString = replace(@myString,substring(@myString,patindex('%[^' + @validChars + ']%',@myString),1),'')

SELECT  @myString AS OutPutString

Get all non-clustered indexes

DECLARE cIX CURSOR FOR     SELECT OBJECT_NAME(SI.Object_ID), SI.Object_ID, SI.Name, SI.Index_ID         FROM Sys.Indexes SI             ...