i've got query that using dynamic query and involved using very huge IN clause (it's for account code)

it receive an error that said something like "the queries involved large complex query"

any other approach? this query is for Financial Reports that used more than 5 years record

PS: i'm using SQL 2005 and C#

thanks,