Hi ,

here is the attached data.

I want to use 1st three columns as composite key to update endate column.

I dont have identity column in the table .

I am using cursor as the data is large .

so do i need to create table variable in cursor ?

Actually i am...

I have already done this but thats not the answer.

I want

PREVIOUS DAY OF STARTDATE OF CODE 2 SHOULD BE ENDDATE OF CODE 1

Check the sample output please.

SEE IF THIS HELPS ....

Hi ,

Here is the sample data .

Enddate is currently null .

What i want is the endate of 1st row should be the yesterday (from startdate ) of 2nd row .

2009-01-01...

Nobody to help ?:w00t:

Thanks a lot .

Solved my problem

🙂

Here it is

HI ,

I tried this ..

select tarief ,left(Tarief,len(Tarief)-2)+'.'+right(Tarief,2) from Temp

Its giving result as well as msg as

"Invalid length parameter passed to the LEFT or SUBSTRING function."

Whats wrong with this...

HI ,

It is replicating last two nos.

I dont want it like this .

I want decimal before last two nos .

Thanks

Thanks

But the updated values should also come from flat file .

Means if the primary column matches then update 2nd column of the table with values from flat file .

Is...

Hi ,

Thanks Phil .

U are right. Its a fixed width file and i used ragged right format to exactly define the width of the column .

The problem is solved.

Thanks a lot !

You solved my problem..

I am giving you the example in the attached text file.

Error at Data Flow Task [Derived Column [134]]: Attempt to parse the expression "FINDSTRING((TRIM(STARTD_CVV), "-",1) > 0 ) ? NULL(DT_STR, 8,1252) : STARTD_CVV" failed. The expression might contain an invalid...