Hello,
Does anyone know off-hand what the SQL script to run all of the AUX Performance URL's for one Season is?
We have roughly 140 Classes (AUX Performances) for one Semester (Season) and I need to run a script that will capture all of the individual:
/auxiliary/Reserve.aspx?p=### URL's
Corresponding Performance ID's
Corresponding Peformance Names
at once so I can export them, but I can't remember what it is.
Thanks!
Just select all the of the aux performance numbers a append it the string using season number and anything else you need to filter in the where clause.
example:
select
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
'http://patrons.imaginationstage.org/auxiliary/Reserve.aspx?p='+perf_no as AUX_URL
from t_perf
where season_no = ####--some number