This?

DECLARE @tab TABLE

(

Value DECIMAL (14,7)

)

INSERT INTO @tab (Value)

SELECT 0008.22816 -->> 0000008.0022816

UNION ALL SELECT 069.3142 -->> 0000069.0003142

SELECT T.Value

,OtrApp.ConvVal

,[7.7 Format]= RIGHT(('0000000'+CrsApp.Whole) , 7) + '.' + RIGHT (('0000000'+CrsApp.Frac) , 7)

FROM @tab T

OUTER APPLY ( SELECT CONVERT(VARCHAR(15),T.Value)) OtrApp (ConvVal)

CROSS APPLY (SELECT LEFT (OtrApp.ConvVal , CHARINDEX('.',OtrApp.ConvVal)-1)

,STUFF(OtrApp.ConvVal,1,CHARINDEX('.',OtrApp.ConvVal),'')

) CrsApp (Whole,Frac)