Hi Jeff--Your theory worked! Thanks to all who replied, it's appreciated.

In answer to your question where the Julian date/time came into play, the application back end has legacy extract...

Here's an example of data that I'm trying to make sense of:

startdate datetime

starttime int

startdate ...

PS: What I'm trying to do is match up a start date in normal datetime format of mm/DD/yyyy and match it up with the time portion of the "starttime" field....

Hi Wayne--The Julian format I'm talking about is the typical format for the Julian calendar. The number I used in the example translates to "1900-03-14 00:00:00" when I plug...

CREATE TABLE [dbo].[Qpivot]([Personnel_id] [nvarchar](50) NULL,

[First Name] [nvarchar] (50) NOT NULL,

[Last Name] [nvarchar] (50) NOT NULL,

[Email] [nvarchar] (200) NOT NULL,

[Division] [nvarchar] (50) NULL,

[Region] [nvarchar] (50) NULL,

[Country] [nvarchar] (50) NULL,

[Manager] [nvarchar] (100)...