USE [CAS_Data]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CAST_Holiday_Accrual_hphaclog](
[sacoy] [char](4) NULL,
[sapaywk] [char](2) NULL,
[dahahours] [float] NULL,
[daawrhours] [float] NULL,
[datothours] [float] NULL,
[sa_empno] AS (case when charindex('.',[saempno],(0))>(0) then CONVERT([varchar](20),[saempno],0) when isnumeric([saempno])=(1) then CONVERT([varchar](20),CONVERT([int],[saempno],(0)),(0))...