Greetings,
We are in the process of preparing for a discussion session at this year's Tessitura conference. The session is called Stuff I Stole from Others: Best Plagiarism Ever. We will be discussing the various shared reports, code, or borrowed ideas that you have acquired over the years from other organizations. Could you tell me what your favorite shared project is? Maybe the Change Password utility that emails a user a randomized password, the utility that automatically merges accounts or Address Auto Correction...you tell me!
Thanks,
Laurie Skouge
Software Systems Specialist
Seattle Opera/University of Washington - Meany Hall
A personal favorite of pilfered code is in the job that executes lp_eis_imp_changed_load_new. I used to have to update this job annually with new seasons. The job now creates a string of seasons based on those that are active and that have the display_eis setting set to ‘Y’.
Lucie
Can I steal what you stole?
Matt Hilgers
Director of Operations
Milwaukee Arts Partners
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Lucie SpielerSent: Monday, May 23, 2011 2:20 PMTo: Matt HilgersSubject: RE: [Tessitura Technical Forum] Stuff I Stole from Others Discussion Session
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
declare @seasons varchar(256)
declare @strsize int
select @seasons = ''
select @seasons = @seasons + convert(varchar(3),id) + ',' from tr_season where inactive = 'N' and display_eis = 'Y'
-- select @strsize = len(@seasons) – 1
select @strsize = len(@seasons)
select @strsize = @strsize - 1
select @seasons = substring(@seasons,1,@strsize) + ''
exec eis_imp_changed_load_new @scope = 'F',
@season_str = @seasons,
@include_resold = 'Y'
-steve
Information Technology Manager
Santa Barbara Center for the Performing Arts
1330 State Street, Suite 101
Santa Barbara, CA 93101
(805) 899-3000 x 111 (phone)
(805) 899-3081 (fax)
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt HilgersSent: Monday, May 23, 2011 2:50 PMTo: Steve CarlockSubject: RE: [Tessitura Technical Forum] Stuff I Stole from Others Discussion Session