Deleting multiple performances

I wrote some code to do this a while ago. Please download here if interested:

https://gcloud.guthrietheater.org/s/Kpb6bCxWJymzgzP

Give it a try in test and see if it fits the bill for you.

Hey Chris, you may need to give them the guts of lv_perf_info_gt as well

Troy Nelson said:

Hey Chris, you may need to give them the guts of lv_perf_info_gt as well

Added to Zip. That's just a shortcut view of mine, didn't notice it was in there; T_PROD_SEASON would work, too. 

Thank you both! Looking forward to testing this ruthless deletion. 

Chris JensenCould you send me this code? I tried the link you provided but it doesn't work. I'm faced with having to rip out our entire 2021 season that I built that never went on sale to rebuild it completely differently. 

Michele Keutsch said:

Could you send me this code?

Sure. The links do die off after a few months. I made a new one:

https://gcloud.guthrietheater.org/s/yPtZ4qkmkJRTFMQ

I hope this is helpful. I'll be using this again myself to delete our sadly un-used 20-21 season!

Thank you so much. I appreciate the assist. 

Would it be possible to get an updated link? Hoping this can save my sanity going a month into a new year.

Emmelia Lamphere said:

Would it be possible to get an updated link?

Sure:

https://gcloud.guthrietheater.org/s/49TtsDMgpK4oqnH

incredible - thank you!

Emmelia Lamphere said:

incredible - thank you!

You're welcome! :-)

Declare
@DoDelete        bit = 0
,@CurrPerfNo        int = 0

Declare @tblPerf table (
PerfNo            int
,PerfDate        datetime
primary key (perfNo))

insert into @tblPerf
SELECT perf_no , perf_dt  FROM T_PERF
                                    WHERE 1=1
                                    AND Perf_dt BETWEEN '2/1/22' AND '1/1/23'
                                    AND perf_code like '%GADA'
                                    AND prod_season_no = 21645 --basically whatever logic you want to apply'

Select @@ROWCOUNT  as PerfCount

Select @CurrPerfNo  = Min(PerfNo) from @tblPerf
While @DoDelete = 1 and @CurrPerfNo is not null
Begin
 
    EXEC TP_DELETE_PERFORMANCE @CurrPerfNo
    Select @CurrPerfNo  = Min(PerfNo) from @tblPerf where PerfNo > @CurrPerfNo
end


Select * from T_PERF where perf_no in (Select PerfNo from @tblPerf)