i think this query is enough for me do solve this issue

Thank you

Actually in my SSRS report i have more than one 1 lac records, i have to export this to a excel file. my hardware configuration is very less becuase of...