Thanks alot for helping me Jeff.

Thaks alot Ash.

After looking at the first comments by RBAR, I have deleted the this post. Then i added a new post for the same as per the guidelines by RBAR. After...

Thanks alot Ash

Yeah we are almost there

Let me explain in this way.

RowNum UpdateFrom date ...

Good Morning Jeff,

Here is my explanation:

We have zero for rownum 1. I want to keep this as zero as we dont have data for AOD= 2007-12-01(Previous month of...

Thanks alot for the reply Jeff.

this query worked really well. But i still have the zeros in amount field for the below records.

DateAreaAmountAOD

2008-02-01 BA ...

Thanks Ash for the reply. Unfortunately the query that you have specified is not working as expected.

Date Area AmountAOD New NumberExpected Result

1/1/2008BA ...

Can anybody help me with the below issue?

--===== Create the test table with

CREATE TABLE [dbo].[mytable](

[date] [datetime] NULL,

[Area] [nchar](10) NULL,

[Amount] [nchar](10) NULL,

[AOD] [datetime] NULL

) ON [PRIMARY]

--===== Insert the test...

Sorry for the mistakes. I'll post it correctly.

Hi Mazharuddin,

Thanks lot for the info. Microsoft's document really helped me to understand better.

Could you pls share the below info as you had worked on migration project (Oracle to SQL...