The "AL-" prefix seems like a complete waste. It's the same on every row, so it contains no infomation. If you need it for display purposes, just add it on your output.

If you need an incident number, why does it have to recycle each day? Use an identity column to generate a unique number that is never reused, and use that for the primary key.

Use a high precision UTC datetime so you don't have to worry about duplicated data due to DST, and capture the high precision system datetime at the same time to have the local time for reporting.

select

-- Converted to varchar only for display purposes.

-- Should be stored in a datetime2(7) datatype.

DT_UTC= convert(varchar(27),SYSUTCDATETIME(),121),

DT_LOCAL= convert(varchar(27),SYSDATETIME(),121)

DT_UTC DT_LOCAL

--------------------------- ---------------------------

2011-03-12 04:24:46.9012247 2011-03-11 23:24:46.9012247