Convert Julian Dates in SQL SERVER

-- SQL SERVER JULIAN TO DATE (WHEN DOWNLOADING JULIAN DATE)

-- date field has to be nvarchar or varchar or character.

-- This example is for testing. Use a real field in your SQL table, but make sure it's character-type, not numeric.

declare @DateP char(10)

select @datep=101259 -- ALSO OK FOR 99 YEARS

select sddoco,sdtrdj,sdlitm, dateadd(dd,@datep-(@datep/1000)*1000-1, convert(datetime,"01/01/"+ right(convert(varchar,@datep/1000),2))) as Date_ENT from orders order by sddoco

-- SQL SERVER DATE TO JULIAN

select date_ent,(100+year(date_ent)-2000)*1000+ datediff(d, convert(datetime,("01/01/"+convert(char(4),year(date_ent)))),date_ent)+1 from orders