set ANSI_NULLS ON
    set QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[GetSchedinePS_7]
    (
    @NSchedina Int,
    @AnnoGestionale Int,
    @CodAllog Int
    )
    AS
    BEGIN
    WITH Tab_Componenti(NumSchedina,CompInsert) AS
    (
    SELECT NSCHEDINA, COUNT(*) - 1
    FROM dbo.SCHEDINEPS
    GROUP BY NSCHEDINA
    )
    SELECT Ps.ANNOGESTIONALE,Ps.NSCHEDINA,Ps.Cognome,Ps.Nome,Ps.IDCOMPONENTE,Ps.CODALLOGGIATO,Ps.ncomponenti,TabComp.CompInsert
    FROM dbo.SCHEDINEPS AS Ps
    JOIN Tab_Componenti AS TabComp
    ON Ps.NSCHEDINA = TabComp.Numschedina
    WHERE
    Ps.AnnoGestionale=@AnnoGestionale AND Ps.NSchedina=@NSchedina AND Ps.IdComponente=1 AND Ps.CodAlloggiato=@CodAllog
    END