Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Neal
  •  Neal
  • No customer Topic Starter
2009-08-04T15:08:00Z
I am using VC 5.1.6 and the SQL task. My SQL script (for an MSSQL DB) selects three sets of data in one script. i.e.

Print Set 1 Heading
Select Query 1

Print Set 2 Heading
Select Query 2

Print Set 3 Heading
Select Query 3

However, the Task Output Varibale only displays the "Select Query 1" output. It does not show the print headings nor the out puts from the other 2 select queries. Is there another way to output the full resuults? Or do I need to setup three tasks for this query?
Sponsor
Forum information
Support
2009-08-04T15:20:16Z
Yes, that could be the case - unless you use a stored procedure instead.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top