I got it figured out. The error was in the @whereclause that I was building in a loop. DbArtisian was sending me back an eronious error message that made me think my statement was to large. Thanks for the help anyway.
Is there a size limit to a dynamic select statment. For some reason it is not building the entire statement.
"select " + @report_title + " as report_title, "+
"ac.tail_no, at.aur_mod_des, at.fy, ta.asset_desc, at.last_dd250_dt, act.activity_name, rk.remarks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.