Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
<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>
I don't understand why my RegularExpressionValidator
|RLDC Reporting in Visual studio||11||30|
|Convert Select to DropDownListFor MVC 5||2||30|
|How to compare a value returned by fileupload to ensure it contains 1 of 4 possible filename values (ASP.NET using C#) ?||1||11|