yea sure, i have diffenet tickets running on differnt schedule for example one can run monday to friday 3 times a day and other can run on saturday to...

Yes, I have to change schedule, Could you please let me know  what is the best way to store data in table. Im planning to use SSAS cube in future.thanks!

I feel like merge will reduce the code length and improve the performace..if that is the case i will avoid merge..or is there any we can rewrite above code for...

Yeah i do match on both member Id and name as well.

My case member id is not unique

Thanks,

Dhana

Thanks Phil.

I will check how Soundex() will work in my case

Yes true, I'm not going to use join operator instead I will use Case statement

Member is not unique in...

Hmm. I missed the point character length wont change.."Dhana" and "Dmana".

I don't know how to match. Its typo mistakes by user so have to handle in sql.

Why it will vary...

I will try converting the data after loading. One more question , string data what we have in text file having some spaces.What is the best way to do?. Can...

Thanks Phil, I will check in different server and will see how it goes .

Yes ..heap table and series execution..havent tried for parllel execution

Depends upon data.. One file got 500 rows took 4mins and other file 1000 rows took 7mins..

Yes loading in local temp server.

Yes 15 files, Its newly created and doesn't have any indexes at all.Thanks

GilaMonster:

Thanks for your response; you mean to say if query is big it’s better to use CTE instead of derived table?

Grant Fritchey:

Thanks for your response.

1) I know that...

I have already searched. I'm looking for more information .Thanks

Thanks Jeff for quickly reply. Great Job 🙂

Thanks for quick response...Working fine ..Thank you again 🙂