E
Eric
I have ALOT of complicated
views/inserts/updates/deletes/etc queries in an Access
2000 (but have access to XP2k3) file...it also consists
of a lot of link tabling to get around the 2GB file
limit..
Trying to upsize the queries is failing miserably as the
SQL is trying to use IIF statements (oh my!)/etc
Any tools or something out there to convert this crap to
case when's?
It would take me several months to try and rewrite all
this SQL (I inherited it of course to compound the mess)
Cheers,
Eric
views/inserts/updates/deletes/etc queries in an Access
2000 (but have access to XP2k3) file...it also consists
of a lot of link tabling to get around the 2GB file
limit..
Trying to upsize the queries is failing miserably as the
SQL is trying to use IIF statements (oh my!)/etc
Any tools or something out there to convert this crap to
case when's?
It would take me several months to try and rewrite all
this SQL (I inherited it of course to compound the mess)
Cheers,
Eric