Stored procedure component

06 Oct '15, 11:37 PM
13,922 Views
No Forum Badges

Hello,

I'd like to use the Stored procedure component with an SP that contains dynamic SQL. In fact I create a result set with combined usage of XML Path e Pivot like

User.           Tfr_2013.   TFR_2014    Tfr_2015.   Tfr_2016 .............

User1.           1345.           1578.           1890.          1958

User2.            2345.          3456.           4589.           5678

Where first column and at least one other column are  mandatory, but I  can't definitely know in advance the real number of column. As SP Component needs output parameters coupling, I suspect that it is necessary to create a Custom Component.

Someone had a similar problem or has a bright idea .

Thanks

 

 
x 0
Follow
Answer Answer at this question and get points!
No answers yet
Answer at this question and get points!

Related questions

API documentation? Ayuda Simple List Component Layout personalizado Button to go on another page Can not get generate and run option for DataService Project Criptare dati sensibili nel database CSV Component with utf8 encoding Custom components Custom descriptors Custom Plug-in Custom Time Unit Custom Unit and AJAX / SOAP Custom Unit: Difficult example in Guide ... any suggestions? Data flow from a page which is not visible anymore Dynamic link labelling for Custom Unit Encoding Confirm Dialog file analysis then update MySQL database Filter completed tutorials Google Map Unit Guardar Saltos de LINEA How can I add a credit card payment gateway or integrate paypal in my web app logic? how can i open a pdf file using download dialog How complex can Custom Unit output be? How to run the example from Custom Unit Guide? Is there any custom unit store or repository? Do you create/sell custom units? java.lang.NullPointerException More Custom Unit questions: example of Content and Operation Unit? Need help with Landmark Overlays for Google Map Unit. Personalizzazione del login component Problema Invocation Unit Problems with Custom components: Can't get values from output parameters on ok flow. "Run Now" on a job scheduled to run later Selezione sul giorno "Events Planning" Status ProcessInstance and activityInstance in spanish Twitter Unit - Get Geo location of twitt Usage of the Gantt Unit ¿Visor de imágenes y reproductor de video para la versión 7.2? Image viewer and video player for version 7.2? Web project without initial login form - how to create custom logins? Webratio Add-ons no permite login Webratio don't recognize JSON library WebRatio Platform 7.2 Community Cloud Edition