Pivot Tabe
 

I have created pivot table depending on a view from SQL Server 2000. But
problem is i cant give parameter to view or pivot table so a large data is
been fetched through server to client. Can any one tell me how to map a pivot
table on Stored procedure or a way around it. Simply i need a criteria on
which a Pivot Table is populated.