never mind..fellas

here u go

select

t.num ,

t.strike ,

rt.col2

from #tmp t

cross apply (select

case when (t.strike - strike)...

Paul White (2/20/2010)

---

Here's the non-CTE version:

UPDATE RowsToUpdate

SET notional = ISNULL(new_value, 50)

FROM (

SELECT T1.value_date_minus_1,

...

Because I am using SQL Server 2000

Guys,

thanks for your awesome replies and suggestions but i think i myself got deviated from the original requirement. Below is what I actually need.

if OBJECT_ID('tempdb..#tmp_Dates1') is not null

drop table #tmp_Dates1

create...

Guys,

thanks for your awesome replies and suggestions but i think i myself got deviated from the original requirement. Below is what I actually need.

if OBJECT_ID('tempdb..#tmp_Dates1') is not null

drop table #tmp_Dates1

create...

Ohh buddy - that worked like a charm. I am such a fool not to think from basics.

hi there, below are the steps as per your instructions. Please see if you can help me out

if OBJECT_ID('tempdb..#tmp_Dates') is not null

drop table #tmp_Dates

-- TABLE CREATION

create table #tmp_Dates

(

value_date_intermediate datetime

,value_date_minus_1 datetime

)

--...