ddl

CREATE TABLE [INTIMINGS] (
[EMPID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[INTIME] [datetime] NOT NULL ,
[EFFECTIVE_DATE] [smalldatetime] NULL ,
[END_DATE] [smalldatetime] NULL ,
[ENTERED_BY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_INTIMINGS] PRIMARY KEY CLUSTERED
(
[EMPID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
Insert into timings values(‘1ab’,1899-12-30
09:00.00.00,2003-07-01,00:00:00,’’,jym)
CREATE TABLE [INTIMINGS_HISTORY] (
[EMPID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[INTIME] [datetime] NOT NULL ,
[EFFECTIVE_DATE] [smalldatetime] NOT NULL ,
[END_DATE] [smalldatetime] NULL ,
[ENTERED_BY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_INTIMINGS_HISTORY] PRIMARY KEY CLUSTERED
(
[EMPID],
[EFFECTIVE_DATE]
) ON [PRIMARY]
) ON [PRIMARY]
GO
Insert into [INTIMINGS_HISTORY(‘1CMN’, 1899-12-30 09:00.00.00,’
‘2005-03-01,00:00:00’, ‘2005-02-08,00:00:00’

CREATE TABLE [EMPLOYEE_TIMINGS] (
[ENTRYTIME] [datetime] NOT NULL ,
[EMPID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[TIMETYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[INOUT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[IP_ADDRESS] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_EMPLOYEE_TIMINGS] PRIMARY KEY CLUSTERED
(
[ENTRYTIME]
) ON [PRIMARY]
) ON [PRIMARY]
GO
Insert into EMPLOYEE_TIMINGS(
2003-10-01 00:03:29.000, VVR, S, E, NULL)
2003-10-01 00:03:38.000 SM S E NULL
2003-10-01 00:25:11.000 NA S E NULL
2003-10-01 00:25:18.000 NA S E NULL
2003-10-01 00:25:25.000 AMB S E NULL
2003-10-01 00:38:08.000 KRK S E NULL
2003-10-01 00:51:25.000 KU S E NULL
2003-10-01 02:00:38.000 NZ S E NULL
2003-10-01 05:50:47.000 1FC B S NULL
2003-10-01 06:06:04.000 1IB S E NULL
2003-10-01 06:06:14.000 IH S E NULL
2003-10-01 06:06:21.000 TO S E NULL
2003-10-01 06:07:12.000 EE S S NULL
2003-10-01 06:08:22.000 QX S S NULLwhat is the problem. check quotes in insert
--
Regards
R.D
--Knowledge gets doubled when shared
"raghu veer" wrote:

> CREATE TABLE [INTIMINGS] (
> [EMPID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [INTIME] [datetime] NOT NULL ,
> [EFFECTIVE_DATE] [smalldatetime] NULL ,
> [END_DATE] [smalldatetime] NULL ,
> [ENTERED_BY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> CONSTRAINT [PK_INTIMINGS] PRIMARY KEY CLUSTERED
> (
> [EMPID]
> ) ON [PRIMARY]
> ) ON [PRIMARY]
> GO
> Insert into timings values(‘1ab’,1899-12-30
> 09:00.00.00,2003-07-01,00:00:00,’’,jym)
>
>
> CREATE TABLE [INTIMINGS_HISTORY] (
> [EMPID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [INTIME] [datetime] NOT NULL ,
> [EFFECTIVE_DATE] [smalldatetime] NOT NULL ,
> [END_DATE] [smalldatetime] NULL ,
> [ENTERED_BY] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> CONSTRAINT [PK_INTIMINGS_HISTORY] PRIMARY KEY CLUSTERED
> (
> [EMPID],
> [EFFECTIVE_DATE]
> ) ON [PRIMARY]
> ) ON [PRIMARY]
> GO
>
> Insert into [INTIMINGS_HISTORY(‘1CMN’, 1899-12-30 09:00.00.00,’
> ‘2005-03-01,00:00:00’, ‘2005-02-08,00:00:00’
>
>
>
>
>
>
>
>
>
> CREATE TABLE [EMPLOYEE_TIMINGS] (
> [ENTRYTIME] [datetime] NOT NULL ,
> [EMPID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [TIMETYPE] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [INOUT] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
> [IP_ADDRESS] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
> CONSTRAINT [PK_EMPLOYEE_TIMINGS] PRIMARY KEY CLUSTERED
> (
> [ENTRYTIME]
> ) ON [PRIMARY]
> ) ON [PRIMARY]
> GO
> Insert into EMPLOYEE_TIMINGS(
> 2003-10-01 00:03:29.000, VVR, S, E, NULL)
> 2003-10-01 00:03:38.000 SM S E NULL
> 2003-10-01 00:25:11.000 NA S E NULL
> 2003-10-01 00:25:18.000 NA S E NULL
> 2003-10-01 00:25:25.000 AMB S E NULL
> 2003-10-01 00:38:08.000 KRK S E NULL
> 2003-10-01 00:51:25.000 KU S E NULL
> 2003-10-01 02:00:38.000 NZ S E NULL
> 2003-10-01 05:50:47.000 1FC B S NULL
> 2003-10-01 06:06:04.000 1IB S E NULL
> 2003-10-01 06:06:14.000 IH S E NULL
> 2003-10-01 06:06:21.000 TO S E NULL
> 2003-10-01 06:07:12.000 EE S S NULL
> 2003-10-01 06:08:22.000 QX S S NULL
>