Kako koristiti recordset koji vraca stored procedura?
ALTER PROCEDURE [dbo].[Osnovica1]
-- Add the parameters for the stored procedure here
@DoDatuma nvarchar(10)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
-- SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT Pred, InvBroj, MONTH(dDok) AS Mes, (SUM(NabDug) - SUM(NabPot)) - (SUM(IspPot) - SUM(IspDug)) AS SadVred,
(SELECT (SUM(NabDug) - SUM(NabPot)) - (SUM(IspPot) - SUM(IspDug)) AS Expr1
FROM dbo.Oskar AS t2
WHERE (Pred = t1.Pred) AND (InvBroj = t1.InvBroj) AND (OsD <> '30') AND (MONTH(dDok) <= MONTH(t1.dDok))) AS RunTot,
(SELECT MAX(dDok) AS Expr1
FROM dbo.Oskar AS t2
WHERE (Pred = t1.Pred) AND (InvBroj = t1.InvBroj) AND (OsD <> '30') AND (MONTH(dDok) >= MONTH(t1.dDok))) AS mes2
FROM dbo.Oskar AS t1
WHERE (OsD <> '30') AND (dDok <= CONVERT(DATETIME, @dodatuma, 102))
GROUP BY Pred, InvBroj, MONTH(dDok)
END
Naime ovaj recordset mi je potreban da dalje nastavim neka izracunavanja. Ovo radim jer nisam nasao kako da napravim view sa parametrima.
Ima li neko resenje?