BAM - GL Monthly By Site

gets data from dbo.BB_20RptGLMonthlyBySite_sp (svr-ngl)

1. Query

ALTER PROCEDURE [dbo].[BB_20RptGLMonthlyBySite_sp]
/*

Input: a begin and end date, Company nbr
Purpose: Print GL by month for a selected period by a selected site
*/
(
@BDate datetime,
@SiteNbr int
)
AS
SET NOCOUNT ON
select * from rptglMonthlybysitebarrel d WHERE ((month(d.BlendDate) = Month(@BDate)) AND
(year(d.BlendDate) = year(@BDate)))
AND d.Siteid = @SiteNbr
ORDER BY d.BlendDate