or we can apply if else logic or while in CTE so that if old proj id is not equal to new proj id then it should not do anything...

hi Wayne, falgunoza

here with out useng the left keyword can we get the output because there are some cases below is the eg

below source table:

new proj id ...

thanks falgunoza this helps my need

also can you please help me to understand the code very briefly

thanks

Hi Wayne

thanks a lot its working gud really appriciate it

When you say you added the column in the OLE Source I'm guessing its coming from SQL Server column of type varchar

Yes it is coming from SQL SERVER as varchar...

This code worked for me

select

DWT40034_BZL_VAT_TAX.ROW_ID_NO as C1_ROW_ID_NO,

DWT40034_BZL_VAT_TAX.ETL_PROC_STAT as C2_ETL_PROC_STAT,

DWT40034_BZL_VAT_TAX.INTGRT_CTL_AFF as C3_INTGRT_CTL_AFF,

DWT40034_BZL_VAT_TAX.INTGRT_CNTRY_CD as C4_INTGRT_CNTRY_CD,

DWT40034_BZL_VAT_TAX.INTGRT_SRC_TRX_CD as C5_INTGRT_SRC_TRX_CD,

CONVERT(CHAR(23),DWT40034_BZL_VAT_TAX.INTGRT_SRC_TRX_DT,121) as C6_INTGRT_SRC_TRX_DT,

DWT40034_BZL_VAT_TAX.INTGRT_PUB_APP as C7_INTGRT_PUB_APP,

DWT40034_BZL_VAT_TAX.INTGRT_BUF_SEQ_NBR as C8_INTGRT_BUF_SEQ_NBR,

DWT40034_BZL_VAT_TAX.INTGRT_SRC_FILE as...

I am sorry for irritating you.

But i am helpless

Data is there in DWT40034_BZL_VAT_TAX and even in ROW_ID_NO

I tried that code also

select

DWT40034_BZL_VAT_TAX.ROW_ID_NO as C1_ROW_ID_NO,

DWT40034_BZL_VAT_TAX.ETL_PROC_STAT as C2_ETL_PROC_STAT,

DWT40034_BZL_VAT_TAX.INTGRT_CTL_AFF as C3_INTGRT_CTL_AFF,

DWT40034_BZL_VAT_TAX.INTGRT_CNTRY_CD as C4_INTGRT_CNTRY_CD,

DWT40034_BZL_VAT_TAX.INTGRT_SRC_TRX_CD as C5_INTGRT_SRC_TRX_CD,

CONVERT(CHAR(23),DWT40034_BZL_VAT_TAX.INTGRT_SRC_TRX_DT,121) as C6_INTGRT_SRC_TRX_DT,

DWT40034_BZL_VAT_TAX.INTGRT_PUB_APP as C7_INTGRT_PUB_APP,

DWT40034_BZL_VAT_TAX.INTGRT_BUF_SEQ_NBR as C8_INTGRT_BUF_SEQ_NBR,

DWT40034_BZL_VAT_TAX.INTGRT_SRC_FILE as...

I didn't get what you have said

What to do for that

Hey i tried your code

select

DWT40034_BZL_VAT_TAX.ROW_ID_NO as C1_ROW_ID_NO,

DWT40034_BZL_VAT_TAX.ETL_PROC_STAT as C2_ETL_PROC_STAT,

DWT40034_BZL_VAT_TAX.INTGRT_CTL_AFF as C3_INTGRT_CTL_AFF,

DWT40034_BZL_VAT_TAX.INTGRT_CNTRY_CD as C4_INTGRT_CNTRY_CD,

DWT40034_BZL_VAT_TAX.INTGRT_SRC_TRX_CD as C5_INTGRT_SRC_TRX_CD,

CONVERT(CHAR(23),DWT40034_BZL_VAT_TAX.INTGRT_SRC_TRX_DT,121) as C6_INTGRT_SRC_TRX_DT,

DWT40034_BZL_VAT_TAX.INTGRT_PUB_APP as C7_INTGRT_PUB_APP,

DWT40034_BZL_VAT_TAX.INTGRT_BUF_SEQ_NBR as C8_INTGRT_BUF_SEQ_NBR,

DWT40034_BZL_VAT_TAX.INTGRT_SRC_FILE as...

Can i write like this

SELECT VAT_TAX.ROW_ID_NO = (max(DWT40034_BZL_VAT_TAX.ROW_ID_NO)

from (select

DWT40034_BZL_VAT_TAX.ROW_ID_NO,

DWT40034_BZL_VAT_TAX.INTGRT_CNTRY_CD,

DWT40034_BZL_VAT_TAX.ORD,

DWT40034_BZL_VAT_TAX.ORD_LN,

max(DWT40034_BZL_VAT_TAX.INTGRT_SRC_TRX_DT) as Mydate

...

Ok i got it

Thank you very much

I tried the code you gave, but got error

Msg 8155, Level 16, State 2, Line 1

No column was specified for column 4 of 'MyAlias'.

Msg 4104, Level 16, State 1, Line...

(DT_STR,4,1252)DATEPART("YYYY",GETDATE()) + (DT_STR,2,1252)DATEPART("MM",GETDATE()) + (DT_STR,2,1252)DATEPART("DD",GETDATE())

This is the code that worked out for me

I am sorry for reposting it again. It will never happen.

Thanks very much guys for your replies and...