Jeff Moden (1/4/2014)
To be honest, whomever designed the table with an integer representation of year and month did a great disservice to anyone and everyone using the table and it's going to be a real bugger when the year roles over. Are you allowed to change the datatype of that column?
Yes I can change the datatype ... Its complex bet one time activity..
so I could ...