I have a table that looks like this:
BusinessDate DateTime
JulianDate Int
In the BusinessDate column I have a about 1000 sequential standard dates. I add the JulianDate column and now need to update that column with the appropriate Julian Date based on the date in the BusinessDate column. Any help would be greatfully appreciated.
Thanks,
Art
Database Analyst
Tastefully Simple, Inc.
alorenzini@tastefullysimple.com
" Some days, it's not even worth chewing through the restraints!