Thanks a lot ..it works....

It works for one account , but I will have more in the table, then it takes sum of all and applies same amount to all...

Thanks a lot Bt,

I will try and post my approach even if incomplete with my questions...

Actually, I am not an expert in T-SQL, can think of doing in SSIS but...

@jeff,

I used your code with union all and QUOTENAME,

It works fine with all datatypes...

SELECT 'SELECT ' + QUOTENAME(cal,'''')+',' ...

@dan-2,

Thanks

I tried you code, it works fine for varchar datatype but not for datetime columns....

Is there any thing diffrent when I use this for datetime dattype...

select 'Insert into...

Thanks a lot...

@jeff..

but by loop I can divide my 50 million into 10 parts and update them one by one ...Is that right?

@Bhuvnesh

I have never...

The output of my set should be without ?,? ,<,>...

Well I dont have any list of characters, but yes I can put it like this I want to replace...

Hey Phil,

Actually the requirement is to lookup the updated rows...and dont update them if they are already updated, but since lookup cache the rows, I dont think this can happen,...

Great code Gah...works like a charm........

Thanks a lot for your reply ...

I tried just now for about 4 million and it worked fine...

I will be trying on more rows after...

Hi,

Here is the requirement in detail.

I have to lookup a table address and I am adding addresses in the same DATA FLOW TASK, so when the address is added for...

I have to update all 00000 indicator with matching indicator found in other acno(6 digit) or I have to put it in an error file.

here are my expected results for...

Code looks great

@Eugene Elutin,

IGNORED..........................

@Bt...........

OMG ..........!!!!!!!!!!!!!!

This is an unbelievable code man..... You must be a GGGenius........

Thank you so much for the help. ...

I just ran this code and got the exact results....

now let me...

Hi

Thanks for your help...

but the query is taking lot of time as I have 500,000+ rows..... and also testing this will be huge task for me.........

Is there any other...

ok let me try like this but i have a cte inside another CTE that is not shown here, the one you gave me...