i undertand exactly what are you saying but just need to ask you

which table i have to do the inner join ? because i cannot make inner join on GE_ReservesFile as...

i cannot use or in otherwords dont have access to that table GE_ReserveFile any more so can you show me how to deal with the situation.

i am sorry about that it was my fault it works but how will i insert record in the temp table because i want to sum the column "waiverofpremium"

Thanks a...

SELECT

    a.PolicyNumber,

    a.TableCode,

    a.SeriesCode,   

    a.LossDate,

    a.EffectiveDate,

    b.WaiverofPremium

FROM tableA a

    INNER JOIN tableB b

    ON a.PolicyNumber = b.PolicyNumber AND a.TableCode = b.TableCode AND a.SeriesCode = b.SeriesCode

WHERE DATEADD(yyyy, 10, EffectiveDate) <...

Can you explain little with the syntax because i did used INNER JOIN for that it, did not work.

Can you explain please i dont understand it

Thanks

Thanks

My question is how can i correct the problem with my date issue, when i run the proc I want it to get the date from the column "Date_From" in...

i guess that is not the solution because see when i do the insert in the table Transactioncountss it is getting some weird dates and inserting in the TransactionCountss instead...

it will show 3 in CalcAction column of transactioncount table.Dont you think i have to establish some sort of relationship between two tables such as primary key and foreign key...

Value in TransactionCounts- what iam looking for

ID  Month_of_file           CalcAction                  TableValue      CalculatedValue

1      12/1/2004               1                                                      66476

 2      12/1/2004               2                                                     30356

 3     12/1/2004                3                                     A              66293

what i want to do is replace the values of CalcAction Column in TransactionCounts table with the values of CalcAction Column

in the second table which is TransactionCounts_Sort

Values in the table TransactionCounts_Sort-sampledata

 ID     CalcAction                                          SortOrder

 1          Total Record Count                                     1

 2          Record Count of Unique Policies                     2

 3           Record Count by Status                              3

Value in TransactionCounts-sample data

ID  Month_of_file           CalcAction                  TableValue      CalculatedValue

1      12/1/2004      ...

What do you mean i dont understand i guess what are you saying.Can you be a little more clear please.

THANKS

Fine thanks , but looking at my code can you tell me how should i take care about this logic below in my stored procedure

-------------------------------------------------------------------------------------

SELECT CalcAction FROM ClaimCounts_Test

WHERE CalcAction='Total Record...