I'm trying to add a element to an output set that shows the amount paid for the last performance attended. I have the last performance element in the system tables. Where do I add total amount paid for that last performance? I keep getting a datawindow error in the output when attempting to add tck_amt to the SELECT string.
Thanks in advance
Coverting to string error, maybe try the following, convert (varchar,tck_amt) in your select.From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>Sent: 10/5/2016 4:54:31 PMI'm trying to add a element to an output set that shows the amount paid for the last performance attended. I have the last performance element in the system tables. Where do I add total amount paid for that last performance? I keep getting a datawindow error in the output when attempting to add tck_amt to the SELECT string. Thanks in advance--View this message online at http://www.tessituranetwork.com/Community/forums/p/16856/50854.aspx#50854 or reply to this message Adria Gunter | Subscriptions and Groups Manager STUDIO THEATRE 1501 14TH ST NW WASHINGTON DC 20005 T 202-232-7267, ext. (365) F 202-588-5262 www.studiotheatre.org Subscriptions are online! Reserve your group of 10+ today and enjoy a discount! 2016-2017 SEASON MAIN SERIES CLOUD 9 |STRAIGHT WHITE MEN | THE HARD PROBLEM | THREE SISTERS | THE FATHER2016-2017 SEASON STUDIO X MOTHERSTRUCK! | I WANNA FUCKING TEAR YOU APART| NO SISTERS | WIG OUT!
Coverting to string error, maybe try the following, convert (varchar,tck_amt) in your select.
From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>Sent: 10/5/2016 4:54:31 PM
Adria Gunter | Subscriptions and Groups Manager
STUDIO THEATRE
1501 14TH ST NW
WASHINGTON DC 20005
T 202-232-7267, ext. (365)
F 202-588-5262
www.studiotheatre.org
Subscriptions are online! Reserve your group of 10+ today and enjoy a discount!
2016-2017 SEASON MAIN SERIES CLOUD 9 |STRAIGHT WHITE MEN | THE HARD PROBLEM | THREE SISTERS | THE FATHER
2016-2017 SEASON STUDIO X MOTHERSTRUCK! | I WANNA FUCKING TEAR YOU APART| NO SISTERS | WIG OUT!
If you want to concatenate it without a space then, yep! Otherwise, if you want a space, see below.
!.perf_name + ' on ' + convert(varchar(12), !.perf_dt, 107) +' ' + convert (varchar,tck_amt)