Q7.6: Convert months to financial months

To convert months to financial year months (i.e. July = 1, Dec = 6, Jan = 7, June = 12 )

Method #1

select ... ((sign(sign((datepart(month,GetDate())-6) * -1)+1) *
   (datepart(month, GetDate())+6))
      + (sign(sign(datepart(month, GetDate())-7)+1) *
   (datepart(month, GetDate())-6)))
   ...
  from ...

Method #1

select charindex(datename(month,getdate()),
"          July      August    September October   November  December
January   Febuary   March     April     May       June      "
		     ) / 10

In the above example, the embedded blanks are significant.