Index: /trunk/ippTools/share/dettool_find_completed_runs.sql
===================================================================
--- /trunk/ippTools/share/dettool_find_completed_runs.sql	(revision 12424)
+++ /trunk/ippTools/share/dettool_find_completed_runs.sql	(revision 12424)
@@ -0,0 +1,26 @@
+SELECT DISTINCT
+   det_id,
+   iteration
+FROM
+    (SELECT DISTINCT
+        detRun.det_id,
+        detRun.iteration,
+        detInputExp.exp_tag
+    FROM detRun
+        LEFT JOIN detInputExp
+        ON detRun.det_id = detInputExp.det_id
+        AND detRun.iteration = detInputExp.iteration
+    LEFT JOIN rawExp
+        ON detInputExp.exp_tag = rawExp.exp_tag
+    LEFT JOIN detResidExp
+        ON detRun.det_id = detResidExp.det_id
+        AND detRun.iteration = detResidExp.iteration
+        AND detInputExp.exp_tag = detResidExp.exp_tag
+   WHERE
+        detRun.state = 'run'
+   GROUP BY
+        detRun.det_id,
+        detRun.iteration
+    HAVING
+        COUNT(detResidExp.exp_tag) = COUNT(detInputExp.exp_tag)
+    ) AS residdetrun
Index: /trunk/ippTools/src/dettool.c
===================================================================
--- /trunk/ippTools/src/dettool.c	(revision 12423)
+++ /trunk/ippTools/src/dettool.c	(revision 12424)
@@ -5497,32 +5497,9 @@
     // compare the counts of exp_tags
 
-    psString query = psStringCopy(
-        "SELECT DISTINCT\n"
-        "   det_id,\n"
-        "   iteration\n"
-        " FROM\n"
-        "   (SELECT DISTINCT\n"
-        "       detRun.det_id,\n"
-        "       detRun.iteration,\n"
-        "       detInputExp.exp_tag\n"
-        "   FROM detRun\n"
-        "       LEFT JOIN detInputExp\n"
-        "       ON detRun.det_id = detInputExp.det_id\n"
-        "       AND detRun.iteration = detInputExp.iteration\n"
-        "   LEFT JOIN rawExp\n"
-        "       ON detInputExp.exp_tag = rawExp.exp_tag\n"
-        "   LEFT JOIN detResidExp\n"
-        "       ON detRun.det_id = detResidExp.det_id\n"
-        "       AND detRun.iteration = detResidExp.iteration\n"
-        "       AND detInputExp.exp_tag = detResidExp.exp_tag\n"
-        "   WHERE\n"
-        "       detRun.state = 'run'\n"
-        "   GROUP BY\n"
-        "       detRun.det_id,\n"
-        "       detRun.iteration\n"
-        "   HAVING\n"
-        "       COUNT(detResidExp.exp_tag) = COUNT(detInputExp.exp_tag)\n"
-        " ) AS residdetrun\n"
-        );
+    psString query = pxDataGet("dettool_find_completed_runs.sql");
+    if (!query) {
+        psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");
+        return false;
+    }
 
     {