Thank you for the quick reply.

I tested the query. But the logic doesn't get the expected result when the interval between date varies. Inserted below data and the...

You can try this..but I'm afraid this can be standard soln...go for ##table

Declare @sqlquery varchar(max)

Set @sqlquery='declare @tbl_temp table(applicationid int, avoid int)'

Set @sqlquery=@sqlquery+'insert into @tbl_temp...

instead of executing join query using variable..directly place the join statement after insert statements..this will work

Thanks

So, if my understanding is correct. This service account will act as windows Authentication while running the ssis job.

am i right?

SCD 2 Type

yes champ...

Here it is

Table 1 has 200 columns and 6million records with column1 is clustered index.

Table 2 has 200 columns and 1 million records (with updated details n addtional records)

Eg..

DELETE FROM...

Hi,

It gives the same error...

Pls provide alternate..?

Gugan

Hi,

Thanks a lot...query works fine. Its saves huge processing time and an alternate to cursor.

Hi,

Pls provide any hint...would be great.

Thanks in advance..

Hi,

have checked the query..need help how to modify it. ie.,

given query updates the result in minimum date row..

C1 C2 DATE RESULT

001 A1 2009-01-01 27

001 B1...

Hi,

Thanks..

forgot to mention... have used clustered index in my table1 still it is taking huge time.

i.e.,

Clustered index (c1,date,c2)

Also pls clarify wat is nextdate(table) in your query.

DECLARE

@c1 VARCHAR(5),

@c2 VARCHAR(5),

@date datetime,

@c1_i VARCHAR(5),

@c2_i VARCHAR(5),

@date_i datetime,

@RESULT INT

@c2 CURSOR

SET @c2 = CURSOR FOR

SELECT c1,c2,date FROM table1

OPEN @C1

FETCH NEXT FROM @C1 INTO @c1,@c2,@date

WHILE @@FETCH_STATUS=0

BEGIN

SET @c1_i=@c1

SET...

Hi Bob / Jeff,

Thanks a ton... for a wonderful query technique.

hI,

This will work

like '[2]' or i like '%,2,%'