SQL Server Performance

StoreProcedure

Discussion in 'Getting Started' started by maideen, May 9, 2011.

  1. maideen New Member

    HiI have created the store procedure with Pivot tableIt works fine But My Problem is, i don't know how to populate result in List view or any reports or store in temp database.I am using vb 6. Pls help me-------- this is the store procedure start -------------set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[sp_pivot_by_Year](@vYearNo nvarchar(20),@vMonthNo nvarchar(20))ASBEGINSET NOCOUNT ON;SELECT * FROM ( SELECT YEAR(sdate) [Year], CASE MONTH(sdate) WHEN 1 THEN 'January' WHEN 2 THEN 'February' WHEN 3 THEN 'March' WHEN 4 THEN 'April' WHEN 5 THEN 'May' WHEN 6 THEN 'June' WHEN 7 THEN 'July' WHEN 8 THEN 'August' WHEN 9 THEN 'September' WHEN 10 THEN 'October' WHEN 11 THEN 'November' WHEN 12 THEN 'December' END as [Month], nocopies,area FROM StandingOrder where Yearno=@vYearNo and Monthno>=@vMonthNo) TableDatePIVOT ( SUM(nocopies) FOR [Month] IN ( [January],[February],[March],[April], [May],[June],[July],[August], [September],[October],[November],[December] )) PivotTableEND---------------- end --------------------
  2. satya Moderator

    Welcome to the forums.
    You can use the TABLE variable or store the values into a temp table within that Stored procedure.
  3. Madhivanan Moderator

    When you execute the code in fornt end application, it will receive the resultset which you can process further

Share This Page