<asp:SqlDataSource ID="sdsBonuses" runat="server" ConnectionString="<%$ ConnectionStrings:AdHocReportingConnectionString %>" SelectCommand = "select approved_denied_by=case when b.bonus_status = 'Denied' then denied_by when b.bonus_status = 'Approved' then approved_by else null end, approved_denied_date=case when b.bonus_status = 'Denied' then denied_date when b.bonus_status = 'Approved' then approved_date else null end, b.*,rtrim(p.first_name)+' '+rtrim(p.last_name) Name,rtrim(ps.first_name)+' '+rtrim(ps.last_name) submitter_name from bonus_local b, people p , people ps where ps.network_account = b.created_by and p.employee_id = b.employee_id and b.is_deleted=0 and b.bonus_status in ('Pending Approval','Denied','Approved') /* and employee_status<>'terminated' */ and case b.bonus_status when 'Denied' then datediff(dd,denied_date,getdate()) when 'Approved' then datediff(dd,approved_date,getdate()) else 0 end < 1 and p.charge_to_location in ( select distinct location_num from role_location a, gldm_location b where scheme_cd ='PRO' and role_cd <>'spprt' and employee_id = (select employee_id from people where network_account = '" + Session["uid"].ToString() + @"') and ( a.location_cd_prefixed = 'div0'+rtrim(b.division_num) or a.location_cd_prefixed = 'com0'+rtrim(b.company_num) or a.location_cd_prefixed = 'OPE0'+rtrim(b.operation_num) or a.location_cd_prefixed = 'BUS0'+rtrim(b.business_unit_num) or a.location_cd_prefixed = 'TER0'+rtrim(b.territory_num) or a.location_cd_prefixed = 'MAR0'+rtrim(b.market_num) or a.location_cd_prefixed = 'ARE0'+rtrim(b.market_num) or a.location_cd_prefixed = 'Meg0'+rtrim(b.mega_location_num) or a.location_cd_prefixed = location_num ) ) order by rtrim(p.first_name)+' '+rtrim(p.last_name) " > </asp:SqlDataSource>
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.