In this publication titled how to convert a date to julian date in sql, I have provided a complete image from start to finish ,Please look below
