It is possible by using this script add a number of sps at once , rather than keep changing the path to point to a different sp

For example;

INSERT...

sorry reason for the errors is cause i didnt add any value for the last column. You enter numeric number for that field.

suggested outcome is at the top, "output"

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))...

Try rounding the column in the where clause and select it as a datetime field. It worked for me. problem is there maybe a date which is further than year...