SQL task output in another sql task - VisualCron - Forum

Community forum

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Offline karthik0108  
#1 Posted : Tuesday, February 11, 2020 4:36:04 PM(UTC)
karthik0108

Rank: No customer

Joined: 2/11/2020(UTC)
Posts: 1
United States
Location: Illinois, Chicago

Hi,
I have a job with multiple sql tasks (15), now all these tasks needs a temporary table with some value and a match needs to be made against it.

My question is, is it possible to use result set of one task and use it in another sql task?

I hope there is an easier way then to create the same temp table in all 15 task.

Edited by user Tuesday, February 11, 2020 5:06:00 PM(UTC)  | Reason: Not specified

Offline Support  
#2 Posted : Wednesday, February 12, 2020 11:55:44 AM(UTC)
Support

Rank: Official support

Joined: 12/1/2015(UTC)
Posts: 299

Thanks: 44 times
Was thanked: 15 time(s) in 14 post(s)
Originally Posted by: karthik0108 Go to Quoted Post
Hi,
I have a job with multiple sql tasks (15), now all these tasks needs a temporary table with some value and a match needs to be made against it.

My question is, is it possible to use result set of one task and use it in another sql task?

I hope there is an easier way then to create the same temp table in all 15 task.


Hi Karthik,

Are you a customer today? I need to place you in your company portal to keep things organized if you are (or what is your company email? we prefer users using company emails rather than yahoo/gmail)

As for your question, first, what version are you using?

Edited by user Wednesday, February 12, 2020 11:56:20 AM(UTC)  | Reason: Not specified

Michael
Support
http://www.visualcron.com

Please like VisualCron on facebook!
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Scroll to Top