RE: How long to sea mail a package to the UK from australia? I can&#39;t seem to find a specific time period for how long it takes to mail packages to the UK through sea mail... except dates for Christmas deliveries, which are almost 3 months prior.
One thing a suspense date IS NOT, it is not a date by which time something is required to be done in most cases. It's just a control for any needed follow up. In the real world, a suspense date is a date that something needs to be done by.
The first line creates a new column which will be set to the current date when inserted into and the second adds the 30 days on. alter table computed_table add currdate datetime default GETDATE() alter table computed_table add date_2 as DATEADD(day,30,currdate) persisted.