Set DateFormat DMY

Select DATENAME(MM,TransHdr.TransDate)As Month_Name,--(It Shows Only Months Name)

Count(TransHdr.TransNum) As Total_Test,

LAG(TransHdr.TransNum,1,0)As Prvs_transaction-- Over (Order by Month(TransHdr.TransDate)) As Prvs_transaction)

From...