AspWebSolution Forums » Products » ASP DataGrid

index | search | no replies | posting guidelines | help

» »

:: store procedure :: show all messages

Post a New Message | Post a Reply

Aug 19 2004, 8:29 PM

Re: store procedure

Post a Reply

Yimei

from: Myrtle Creek, OR

My other store procedures work fine with Grid.  But I keep on getting "Subscript out of range" error on this one.  I think it might have something to do with trying to make a temp table and cross tab record set.  The sp works from Query Analyzer. The store procedure is as follow:
CREATE PROCEDURE qaur
    @var1 VARCHAR(6),
    @var2 VARCHAR(6)
AS
DECLARE @SQL  NVARCHAR(200)
select P.* into #ztmp
from (SELECT yyyymm,
    SUM(CASE DCO WHEN 'A' THEN Days ELSE 0 END) AS A,
    SUM(CASE DCO WHEN 'B' THEN Days ELSE 0 END) AS B,
    SUM(CASE DCO WHEN 'C' THEN Days ELSE 0 END) AS C,
    SUM(CASE DCO WHEN 'D' THEN Days ELSE 0 END) AS D,
    SUM(CASE DCO WHEN 'E' THEN Days ELSE 0 END) AS E,
    SUM(CASE DCO WHEN 'F' THEN Days ELSE 0 END) AS F,
    SUM(CASE DCO WHEN 'G' THEN Days ELSE 0 END) AS G,
    SUM(CASE DCO WHEN 'H' THEN Days ELSE 0 END) AS H,
    SUM(CASE DCO WHEN 'I' THEN Days ELSE 0 END) AS I,
    SUM(CASE DCO WHEN 'J' THEN Days ELSE 0 END) AS J
FROM zQAUR
GROUP BY yyyymm
HAVING yyyymm BETWEEN @var1 AND @var2) as P

SET @SQL= 'SET ANSI_WARNINGS OFF;SELECT * FROM #ztmp;SET ANSI_WARNINGS ON;'

EXECUTE sp_executesql @SQL
GO

Thanks for your help.

Pages: (1) [1]