CREATE TABLE #temp (Period char(6),PolicyNumber varchar)

INSERT INTO #temp (Period,PolicyNumber)

SELECT DISTINCT CONVERT(char(6),DATEADD(year,10,EffectiveDate),112),PolicyNumber

FROM GE_Transaction

WHERE Status='A' AND DATEADD(year,10,EffectiveDate) > (DATEADD(mm, 1,MonthReported) - 1) and Month_of_file='20060901'

SELECT a.Period,COUNT(*) AS [Count]...

still not clear getting following message

Server: Msg 245, Level 16, State 1, Line 2

Syntax error converting the varchar value 'FFG1212267' to a column of data type int.

still gives an error message

Server: Msg 207, Level 16, State 3, Line 2

Invalid column name 'Period'.

i get the following error message when i execute the above suggested query

Server: Msg 107, Level 16, State 2, Line 2

The column prefix 'a' does not match with a table...

SELECT DISTINCT PolicyNumber

from GE_Transaction

WHERE Status='A' AND MonthReported < DATEADD(year,EffectiveDate,10)

i get the following error

Server: Msg 8116, Level 16, State 1, Line 1

Argument data type datetime is invalid for argument 2...

Yes value from GE_Claim

Thanks

iam updating temp table.

both tables have PolicyNumber,SeriesCode,TableCode.EffectiveDate

i just want to update Effective date column in temp table

PolicyNumber, TableCode, SeriesCode,---exists both in GE_Claim and GE_Reserve

LossDate,InClaimFile----------------exists in GE_Claim

WaiverofPremium------------------exists in GE_Reserve

i have created a temp table as follows

create table #tmp

(PolicyNumber varchar(10)

, TableCode  varchar(3)

, SeriesCode varchar(1)

, IssueAge tinyint

, Gender    char

,...

can you show me the syntax how to do it.

Thanks

i have to make a join between table GE_Claim and GE_Reserve.

 can you explain a little more  and show me what are you saying ,may be i did not understood it

Inner...

any other option i have tried all these but no luck any other suggestion?

i am not able to give you data. you can send me and i  can test run the script and make any modification if neccessary

Thanks for your help

CREATE TABLE [GE_Claim] (

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

 [Month_of_file] [datetime] NULL ,

 [CompanyCode] [varchar] (3) COLLATE SQL_Latin1_General_CP850_BIN NULL ,

 [PolicyNumber] [varchar] (10) COLLATE SQL_Latin1_General_CP850_BIN NULL ,

 [CoverageNumber] [tinyint]...

Thanks a lot it works but can you tell me one more thing is there anything wrong with my update statement below with which i want to update my temp...

instead of making an inner join on table GE_ReserveFile can i create a temp table with the same columns as that of GE_Reservefile and populate it and then i can...