• 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 ...