Forum

Welcome Guest! To enable all features please try to register or login.
HD_prijavio
#1 Posted : 19 August 2009 13:04:31(UTC)
HD_prijavio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 1

Was thanked: 2 time(s) in 2 post(s)
Možeš li mi dati screenshot formula buldera koji vuče prosečnu nc iz stored procedure? Koje promenljive treba postaviti.
Hvala unapred.
HD_odgovorio
#2 Posted : 19 August 2009 13:04:31(UTC)
HD_odgovorio

Rank: Datalab

Joined: 14/08/2009(UTC)
Posts: 0

Was thanked: 1 time(s) in 1 post(s)
Promenljive se ne pojavljuju u formula bilderu. Sve radi procedura, odnosno procedura vraća cenu i rabat direktno u poziciju. U formuli stavljaš:
exec _SREDNJA

Procedura:

ALTER procedure [dbo].[_SREDNJA]
@cTip char(2) ,
@cCenRazred char(1) ,
@cKupec char(30),
@cSkladisce char(30),
@cIdent char(16),
@cgValuta char(3),
@dgDatum datetime ,
@nKolicina decimal(19, 6),
@cKolicina char(1)
as

set nocount on

declare
@nVrniCena Float,
@nVrniRabat Float

set @nVrniCena = 0
set @nVrniRabat = 0

select @nVrniCena = ZADNJACENA
from zaloga
where Ident = @cIdent and SKLADISCE = `Veleprodajno skladište`

select @nVrniCena, @nVrniRabat


Kao što vidiš ja trenutnu srednju nabavnu uzimam direktno iz tabele zaliha. Ovako može da se napiše šta god ti treba i uzme direktno iz baze.
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2026, Yet Another Forum.NET
This page was generated in 0.412 seconds.