Thank you for the reply, Yes I agree with you...

My requirement is like user will upload the excel in which there will be a lab id, block id, mutation1, value1,mutation2,...

Actually joining the same table n number of times based on the where clause user selected from UI... for each where joining once the able.

select * from (select distinct T65.[Sequenom_ID],T65.[Lab_Number],T65.[BlockID],T65.[Mutation],T65.[Status],T65.[ChipID],T50.FName...

Thank you very much Phil for the reply...

But it is happening every time, tested in different database copies.

Thanks for the response

I am having issues when using integration services project from sql server...

USing SSIS how can i import data from MS Access to SQL Server

Can you please suggest...