-- generated by org-babel-tangle
-- [[file:~/Desktop/seb.org::*Test%20file][CP111.sql]]
          -- no longer display the count message
          SET NOCOUNT ON
          
          SELECT TOP 10
                 etpNom,
                 etpID,
          FROM etp
          WHERE etpID
              IN (SELECT actID
                  FROM actions
                  WHERE actID = 338)
              AND
          -- extra condition
              pfiAuth = 1
              AND SUBSTRING(etpCPNum, 1, 3) = "111"
          ORDER BY pfiID
-- CP111.sql ends here
