Hi all,
I have requirement in which.I have to assign the output count of a query to a variable and have the same included in the Body of Email notification stage.
(E.g).
1).select count(*) as COUNT from xxxx
2).This Output "COUNT" has to be assigned to some variable say "ENV_Variable"
3).This "ENV_Variable" has to be assigned to the Email body of Email notification.
How can this be achieved.Please give your inputs on this.
Thanks In advance.
How to assign a output column to an Environmental variable a
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Mon Feb 22, 2010 1:58 am
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: