Operation Details
Description: Get number of typical picture version associated with a questionnaire version
Sterotype: nsmulti
SQL 
SELECT
  COUNT(*),
  typicalPictureVersionID
INTO
  :count,
  :tpVersionID 
FROM
  TPQuestionnaireLink 
WHERE typicalPictureVersionID IN 
  ( 
  SELECT
    typicalPictureVersionID 
  FROM
    TPQuestionnaireLink 
  WHERE questionnaireVersionID = :questionnaireVersionID 
  ) 
GROUP
  BY typicalPictureVersionID