think I got it.

I did it using temp tables and Cursors.

Here is what I did.

Did a select and insert into Temporary table and then

DECLARE @ClientNbr Int,

...

that is right!!!

anyone??????

Steve Jones - Editor (5/27/2010)

---

So what do you want from this result? You need to define the criteria for what you want. It's not enough to say I want the...

lmu92 (5/27/2010)

---

Then you'd need to use the value of Column2 as a fixed value, since there is no other way to exclude Column0(0)....

The only Input I have is Column1.

I got it resolved. I did a join with the subset of the results and created new column. and it worked for me.

I think it would be better if I post actual string

Select InstallNum, RecordWrittenDt, PolicyEffectiveDt, ActivityType, (Case TransactionDes When Null Then TransactionCd Else TransactionDes End) As TransactionCd, ActivityAmt, InstallBalanceAmt,ISNull(ReceiptTypeCd,'') as ReceiptTypeCd,ISNull(ReceiptId,'')...