Viewing 3 posts - 1 through 3 (of 3 total)
I dont see / understand how this will give me the Top 25 records for each comp/dept.
October 19, 2005 at 10:14 am
So you are suggesting handling it in the Stored proc...
Here is my current procedure:
declare @currentdate datetime
set @currentdate = getdate()
SELECT dbo.CreateReportString('NBUR1200-1', A.NBUCMPNY, A.NBUDEPT) as Co_Dept,
dateadd(d, -1, convert(datetime, cast(month(@currentdate) as varchar(2)) +...
October 19, 2005 at 8:19 am
That is what I did for one of the reports. The one that is still giving me trouble is the one that needs the top 25 per comp/dept. I believe...
October 19, 2005 at 8:03 am
Viewing 3 posts - 1 through 3 (of 3 total)