I'm pulling data from a legacy SQL Server transactional database into a SQL Server reporting database. In the legacy system, many of the tables have fields:
UserDateStamp (DateTime, Null)
UserTimeStamp (char(8), NULL)
All of the records which have at least one of these values have both, but I would like to combine them in a query into a value which can be inserted into a DateTime2 data field.