On Sale Notification RSS

Here is a query that gives you the event name, and production season number for performances that have either have a status of on sale or have the on sale indicator checked off.  What we do is something  like this but we also only show 60 days worth of upcoming events.  Also we cache the RSS feed for a day.  This is to help with cutting down the frequency the feed has to make a sql server call to for generating the feed.  If you would like I can make our .NET code available for you.

select distinct ps.prod_season_no,i.description from t_prod_season ps Join t_perf p on p.prod_season_no = ps.prod_season_no join t_inventory i on i.inv_no =ps.prod_season_no where avail_sale_ind='Y' or perf_status=1

Jon:

1. Love your avatar.

2. Thanks for the code. I really appreciate it. I may hit you up for the .net source in a few weeks. I really appreciate it.

Chris

Jon:

1. Love your avatar.

2. Thanks for the code. I really appreciate it. I may hit you up for the .net source in a few weeks. I really appreciate it.

Chris