Hello,
I am attempting to convert my first Infomaker report into an SSRS report with a few additional extras. The Hold Code Summary Report. The part that I can't seem to get to work is the Hold Code Start and End Date parameter. Is there something additional I need to do to this part of the procedure to get that part to work?
select a.perf_no, a.zone_no, a.zmap_no, c.hc_no, avail = Case When a.seat_status in (4, 6) Then 'Y' Else 'N' End, b.* into #cwr1
from [dbo].tx_perf_seat a
JOIN [dbo].t_seat b ON a.seat_no = b.seat_no
JOIN [dbo].tx_perf_hc c ON a.seat_no = c.seat_no and a.perf_no = c.perf_no
JOIN #tperf d ON a.perf_no = d.perf_no
where c.priority = 1
and (IsNull(@show_avail_only, 'Y') = 'N' OR a.seat_status in (4, 6))
and (charindex(',' + convert(varchar, c.hc_no) + ',' , ',' + @hc_str + ',') > 0 or ISNULL(@hc_str, '') = '')
and c.start_dt between IsNull(@hc_start_dt, '1900-1-1') and IsNull(@hc_end_dt, '2999-12-31')
Thank you!
Kelly