salve ragazzi,
ho il seguente codice:
WITH Componenti(ID, NumComp) AS
(
SELECT NSCHEDINA, COUNT(*) - 1
FROM dbo.SCHEDINEPS
GROUP BY NSCHEDINA
)
SELECT PS.NSCHEDINA, PS.Cognome, PS.Nome, Comp.NumComp
FROM dbo.SCHEDINEPS AS PS
JOIN CTE_Dipendenti AS Comp
ON PS.NSCHEDINA = Comp.ID
WHERE ANNOGESTIONALE=2007 AND
NSCHEDINA=2 AND
PS.IDCOMPONENTE = 1 AND
CODALLOGGIATO=17;
come faccio ad inserirlo in una classica stored di sql server?
composta dalla seguente base?
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
AS
BEGIN
END
GO
Ciao
Cirillo Fabio
www.wondernet.biz
fabio@wondernet.biz
http://blogs.dotnethell.it/fabiocirillo/