Index: Ringtoets/Piping/src/Ringtoets.Piping.IO/Builders/SoilDatabaseQueryBuilder.cs
===================================================================
diff -u -re1a8e98d60853beefbdb8c84e70f14165680ad7b -r0fbb881c5c82f540f01772234b3c1faadfab07f9
--- Ringtoets/Piping/src/Ringtoets.Piping.IO/Builders/SoilDatabaseQueryBuilder.cs	(.../SoilDatabaseQueryBuilder.cs)	(revision e1a8e98d60853beefbdb8c84e70f14165680ad7b)
+++ Ringtoets/Piping/src/Ringtoets.Piping.IO/Builders/SoilDatabaseQueryBuilder.cs	(.../SoilDatabaseQueryBuilder.cs)	(revision 0fbb881c5c82f540f01772234b3c1faadfab07f9)
@@ -19,7 +19,6 @@
 // Stichting Deltares and remain full property of Stichting Deltares at all times.
 // All rights reserved.
 
-using Ringtoets.Piping.IO.SoilProfile;
 using Ringtoets.Piping.IO.SoilProfile.Schema;
 
 namespace Ringtoets.Piping.IO.Builders
@@ -175,5 +174,16 @@
                 StochasticSoilModelTableColumns.StochasticSoilModelName,
                 StochasticSoilModelTableColumns.TableName);
         }
+
+        public static string GetStochasticSoilProfileProbabilitiesValidQuery()
+        {
+            return string.Format(
+                "SELECT COUNT({1}) == 0 as {0} " +
+                "FROM {2} " +
+                "WHERE {1} NOT BETWEEN 0 AND 1 OR {1} ISNULL;",
+                StochasticSoilProfileTableColumns.HasNoInvalidProbabilities,
+                StochasticSoilProfileTableColumns.Probability,
+                StochasticSoilProfileTableColumns.TableName);
+        }
     }
 }
\ No newline at end of file