Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need some advice
Message
From
22/03/2000 09:33:33
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Need some advice
Miscellaneous
Thread ID:
00348846
Message ID:
00348846
Views:
52
Just wrote my first SP. Would like some advice for having a computed field of running balance in the below code

if exists (select * from sysobjects where id = object_id('dbo.getled6') and sysstat & 0xf = 4)
drop procedure dbo.getled6
GO

CREATE PROCEDURE getled6
@ledcode varchar(10),
@fromdate datetime,
@TODATE DATETIME
AS

CREATE TABLE #db_ledger (
glcd char (10) ,
gldt datetime ,
glfl char (8) ,
glblno char (10) ,
glblsrno char (5) ,
glamnt numeric(18, 2) ,
gltrcd char (10) NULL ,
matched numeric(18, 2) ,
balance numeric(18, 2) ,
glnarr varchar (255)
)

insert into #db_ledger (glcd,gldt,glfl,glblno,glblsrno,glamnt,glnarr)
select glcd, gldt=@fromdate, glfl = "OPENING",glblno='',glblsrno='',GLAMNT = SUM(GLAMNT) ,"Opening Balance"
from genled where glcd = @LEDcode
and gldt < @fromdate
GROUP by glCD



insert into #db_ledger
SELECT *
FROM GENLED
WHERE GLCD = @LEDCODE AND GLDT >=@FROMDATE AND GLDT <= @TODATE
ORDER BY GLDT

select * from #db_ledger
GO
Next
Reply
Map
View

Click here to load this message in the networking platform