Hi Lynn

Well basically the software we are using has a system setting that is a minumum number of hours between OUT and IN where the hours are to be added...

Hi Lynn

Thanks so much for your help and your tips on submitting a question. I will be sure follow this format in the future.

I noticed that you included ft.FormatTime. Is...

Hi Lynn

Thanks for the tips.

Here is the table structure.

CREATE TABLE [dbo].[E_TimeCards](

[TC_ID] [bigint] IDENTITY(1,1) NOT NULL,

[TC_EMPNO] [nvarchar](9) NOT NULL,

[TC_ADATE] [datetime] NOT NULL,

[TC_TYPE] [smallint] NULL

GO

Sample Data: [TC_TYPE] = 1 (Out Punch)...

I am having a problem when I run the script on the new database. I get several errors that I do not have permissions to create several tables. When I...