If you search the scripts there are several methods...

CREATE PROCEDURE proCrossTabMulti

 (

  @strSELECT NVARCHAR(750), -- 'SELECT A,B'

  @strFROM NVARCHAR(750), -- 'FROM atabletest INNERJOIN atbl1 ON atbl1.int1 = atabletest.int1'

  @strWHERE NVARCHAR(750), -- 'WHERE (((A <>...