Hello Mike/Bt...

I cannot use this update as my data is very large more than 100000 and is always increasing...

I there any way to add it in the query as a...

Any help on this?????????????

I do want to store it, but first I want to derive sequence in my Source query and then in TARGET I want to store it, I dont have any...

Response to Mike01

Thanks for your reply...

but there is no column named as Sequence in my source table..

I think its my mistake I gave code like that...

CREATE TABLE [#abc1](

...

Here is the solution in SSIS...

Pls Let me know , how can I do the same in T-SQL, do you want me to post it there again

Hi all,

Any help on this,

The only way I can think of doing this is to maintain a separate stage table for every account with 2 dates in 5 date range...

here is some sample data...

CREATE TABLE [abc1](

[I_KEY] [int] NULL,

[A_NO] [nvarchar](14) NULL,

[IN_DATE] [datetime] NULL,

[Sequence] [int] NULL

)

INSERT INTO abc1 ( I_KEY,A_NO,IN_DATE,Sequence) VALUES ( 1, '23', 'Jul ...

Hi ,

Thanks but I cannot think of this scenario being solved using CTE...

What do you think I should use in Partition by for this scenario as I cannot partition...