Search results for query: *

The following is the copy of my SP. Could you enlighten me with the grouping function in SP? i am not sure where should I start. Thank you very much. CREATE PROCEDURE dbo.dt_receiver21 @recNumber varchar(30), @POSTED int -- 0 not posted, 1 posted AS if @POSTED = 0 SELECT...

I am using one data source for my stored procedure. However, I link different databases within my SP. Is that the problem? There is no way for me to combine all data into one database due to the nature of the software I am trying to produce report for. This accounting software (Great Plains)...

I am using MS SQL 2000 and it doesn't seem to have much effects upon the preformance. I tried enabling the server grouping function and creating parameter fields in stored procedure, but they don't seem to have much effect either.

I enabled the server grouping function and created parameter in the Stored Procedure, and the report still has performance problem. It took almost 10 minutes to complete the job. What else I can do to avoide the performance bottleneck? Thanks.

I experienced the same problem with the use of stored procedure embedded in the report. I tried enable the server side grouping function, but it doesn't seem to have much effect on the performance. Is there any other way to go around it?

CREATE PROCEDURE dbo.dt_po AS SELECT JPUS.dbo.POP10110.PONUMBER AS PONUMBER, JPUS.dbo.POP10110.ORD AS ORD, JPUS.dbo.POP10110.ITEMNMBR AS ITEMNUMBER, JPUS.dbo.POP10110.ITEMDESC AS ITEMDESCRIPTION, JPUS.dbo.POP10110.VENDORID AS VENDORID, JPUS.dbo.POP10110.QTYORDER AS QTYORDER...