Thanks you all guys for your responses. I'll implement this and let you know..

Thanks for your response. Its kind of when the client retrieves the data.

again, the 32 character count should start from where the pipe was placed.

Gents,

Many thanks for all your answers. I'll implement both strategies (row_number() & CTE) and let you know how it did.

K

friends, Pl ignore my previous query. this is what I've tried and the result set:

select t.trd_eff_tms, fx.prc_tms, fx.fxrte from transrptccy t left outer join fxrate fx ...

Addicted - you got it right.

Champion - this is what I've tried,bbut it's giving only the matching record but not the other one.

select t.trd_eff_tms, fx.prc_tms, fx.fxrte from fxrate fx left...

The result set I've given is HOW I WANT THE DATA TO BE. Pl help on how to write a query to achieve that result set.

Thanks guys. will try and keep u posted.

thanks for responding. yes, it can be done thru a running total query. But, stuck on how to update a record when the counter reaches/near 500.

thx

thanks dude.  the second solution works for me.

Thanks Ken and Sean.  My earlier case also worked when I introduced another instance of the pinf table. 

Thank you very much guys.  It worked.  Sorry for missing one more piece from original query, which selects one more column.

select MAIN_CODE, SUB_CODE, NAME,

 DAYS=(select INTVALUE from PINF p2

   where p2.MAIN_CODE =*...

Run DBCC INPUTbuffer to check what exactly the processes 149 and 151 are running.