when create store procedure to use last code (Posted - 04/25/2013 : 03:30:39 )and call Sp by c# reports no return columns like select statementhow to return columns ?alter proc SP_Report_atend_lectureasbeginDECLARE @Pivot VARCHAR(4000) = '', @sql VARCHAR(MAX) = '', @PivotCols VARCHAR(MAX) ='COALESCE( 'SET @Pivot = STUFF( (SELECT ',[' + CAST( lesson_number AS VARCHAR) +']' FROM View_1 GROUP BY lesson_number FOR XML PATH('')), 1, 1 , ''); SET @PivotCols = @PivotCols + REPLACE( @Pivot, ',', ', ''0'' ), COALESCE( ') + ', ''0'')'SET @sql = @sql + ' SELECT ID_student, ' + @PivotCols +' FROM ( SELECT lesson_number, ID_student, stae FROM view_1 where stae=''no'' or stae=''yes'' ) AS PPIVOT( Max(stae) FOR lesson_number IN ( ' + @Pivot + ' ) ) AS pv ';EXEC (@sql)end
please help meto create report in c#http://aman-services.netfor office???? ???? ???????