![Smile :)](./images/smilies/icon_smile.gif)
Need to find sum(sal) for all the active employees
Moderators: chulett, rschirm, roy
Thanks james i got itjwiles wrote:Click on the Output->Columns, then right-click on the generated column select Edit Row...
Generator->Algorithm
Choose your type. The algorithm types available vary depending on data type. For char/varchar and this job, I would choose Cycle and give it only one value to cycle through. The other type is Alphabet and you provide a string of characters for it to cycle through (again, for this job just enter one character). Other data types should be self-explanatory.
Regards,
Praveen