I am using the builtin DATEPART function to retrieve month, day and year from a date so I can pass it to the DATENAME function: Now that I have Month, Day, Year values individually, I pass it to my DATENAME to get the Weekname of the date I want: This returns an incorrect Day Name.
Leaving Main Life Sequence. When a massive star has expended all of its core hydrogen, this means that the gravitational forces pushing inward will overcome the fusion forces which had been pushing outward. The outer layers of the star will then compact inwards.
Stars (the stellar light sources) can die when they use up their supply of lighter elements (hydrogen, helium). Depending on the size of the star, its fate can be quite different. Small stars (23% the mass of our Sun, or less) - usually end up as white dwarf stars, but can undergo a nova process if they accumulate fusionable mass on their exteriors. The smaller stars will never fuse helium when their hydrogen is used up.