Hey Wayne..

Thanks a lotttttttt for your help....

i am using the Sqlserver 2005 Standard Edition..

Thnx

Anil:-D

Hey

Thnx for Replying dude....:-)

insert into [dbo].Eam_Member_Eligibility_asdf([Span_Num] ,[Eam_Span_Id] ,[Member_Code_Num] ,[Subscriber_Id] ,[Medicare_Id] ,[Cms_Contract_Id],[Start_Date] ,[End_Date],[Last_Ind],[Source_Table],[Created_Datetime],[Last_Updated_Datetime]) values(1,11858833,11437,'071720358','429628828A','R3444',cast('2007-07-01 00:00:00.000' as datetime),cast('2008-01-31 00:00:00.000' as datetime),1,'tbENRLSpans',cast('2010-06-18 17:20:00.000' as datetime),cast('2010-06-18 17:20:00.000' as datetime))

insert into [dbo].Eam_Member_Eligibility_asdf([Span_Num] ,[Eam_Span_Id] ,[Member_Code_Num]...

ALTER TABLE [dbo].[Eam_Member_Eligibility] ADD CONSTRAINT [PK_Eam_Member_Eligibility] PRIMARY KEY CLUSTERED

(

[Eligibility_Id] ASC

)WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [Data]

CREATE NONCLUSTERED INDEX [IX_Eam_Member_Eligibility_2] ON [dbo].[Eam_Member_Eligibility]

(

[Member_Code_Num] ASC,

[Start_Date]...

Hey Sorry dude,,I haven't study the instructions......Apologize for that.. Here t=is the insert statements

CREATE TABLE [dbo].[Eam_Member_Eligibility](

[Eligibility_Id] [int] IDENTITY(1,1) NOT NULL,

[Span_Num] [tinyint] NULL,

[Eam_Span_Id] [int] NULL,

[Member_Code_Num] [bigint] NULL,

[Subscriber_Id] [char](9) COLLATE SQL_Latin1_General_CP1_CI_AS...

i guess try it with //(double slash )in case staement

Thnx Anil

Hey ,

THnx Dude, it was working fine..but Span_Num is not incrementing.... herea re the tables and data

CREATE TABLE [dbo].[Eam_Member_Eligibility](

[Eligibility_Id] [int] IDENTITY(1,1) NOT NULL,

[Span_Num] [tinyint] NULL,

[Eam_Span_Id] [int] NULL,

[Member_Code_Num] [bigint] NULL,

[Subscriber_Id]...