Hello, i have had a gentleman on the phone saying that he tried to book his tickets online and it failed, so therefore he attempted to call us and book them. We told him the ususal line of they will release in 30 mins (which is normal for us), but when he called back a few hours later they are still purple and still under his name.
Is there anyway that you can release purple locked seats?
Jennie
And here’s something I stole from someone else here (can’t remember who, sorry) so I don’t have to keep remembering to update the job every time a new season is created:
declare @seasons varchar(1024)
set @seasons = ''
select
@seasons = @seasons + cast(s.id as varchar(8)) + ','
from tr_season s with (nolock)
join tr_season_type y with (nolock) on s.type = y.id
where
isnull(s.inactive, 'N') = 'N'
and
isnull(y.inactive, 'N') = 'N'
set @seasons = left(@seasons, len(@seasons) - 1)
exec tp_check_seat_status_batch @season = null,
@fix_problems = 'Y',
@season_str = @seasons
-steve
Information Technology Manager
The Granada
(805) 899-3000 x 111 (phone)
(805) 899-3081 (fax)