For the first question:

What is the specification for the Serial No? Any incremental ID? Should it contain any information? Should it be a NVE or a Code39?

For the second question:

declare @PFDate datetime

set @PFDate = '2009-03-19 00:00:00.000'

select @PFDate, @PFDate + CONVERT(DATETIME, '15:30')

Greets

Flo