Jack Nolan’s Post

Manager with second most employees: CREATE TABLE employye(   id INT ,   name VARCHAR(100),   department VARCHAR(100),   managerid INT ); INSERT INTO employye (id,name, department, managerid) VALUES (1,'John Smith', 'Engineering', NULL), (2,'Sarah Johnson', 'Sales', NULL), (3,'Michael Brown', 'HR', NULL), (4,'Emily Davis', 'Engineering', 1), (5,'James Wilson', 'Engineering', 1), (6,'Linda Martinez', 'Engineering', 1), (7,'David Lee', 'Sales', 2), (8,'Karen Taylor', 'HR', 3), (9,'Charles Anderson', 'HR', 3); Solution: With cte as( select * from employye where managerid is null ) select manger_name from ( select *, row_number() over(order by empcount desc) as rn from( select cte.name as manger_name, count(employye.name) as empcount   from cte inner join employye on cte.id = employye.managerid group by cte.name  ) a )b where rn = 2

The reality of hiring an outside consultant…. FAST Return on Investment!! Increasing productivity. Increasing profitability. Reducing wasted labor. Reducing wasted material resources. Creating a roadmap to success that crosses departmental accountability, with assigned responsibility. Cuts through red tape. Not effected by CYA culture, corporate politics or tribal knowledge. (Always a factor working from within). Documented cause, effect and cure. Prioritized actionable “to do” list. Finishing Solutions Inc. PaintROI.com Ph 248-568-0051 “We can do it internally”… why haven’t you done it? “We’re too busy”…….exactly. Accept help. “We know how to fix it” …..do you? #paint #coatings #viscositycontrol #sealer #adhesive #potting #manufacturing #fluiddelivery #ROI

Hiring is so simple. Actions speak louder than words. For example when you hire someone and they are usually late or keep missing meetings without notice, they are out right away. If they are constantly behind on projects without prior notice or valid explanation, they are out. If they can't perform as expected for their seniority level, they are out. If they are sick more than usual without any medical reason, they are out. Simple. Actions speak louder than words.

Don't hire us❌! When the project is low-stakes and doesn't require the level of professionalism and expertise that Corporate Streams provides. #ProjectNeeds #ExpertiseRequired #CostConsiderations #BusinessSolutions #BusinessConsulting

Don't hire us❌! When the project is low-stakes and doesn't require the level of professionalism and expertise that Corporate Streams provides. #ProjectNeeds #ExpertiseRequired #CostConsiderations #BusinessSolutions #BusinessConsulting

Are you currently in a hiring position? How are you attracting the best of the best? How is your process performing for you? So many questions... When you are ready to streamline your efficiencies, grab our 14-day Free Trial. www.businessdraft.com Match - Connect - Hire We're here for you! #businessdraft #matchconnecthire #bestofthebest #ALLinONE

Dispelling myths: Hiring a consultant isn’t failure, it’s progress. 📈 Embrace success with Radline Consulting. Fresh perspectives and expert knowledge

What is the process of a Waste Audit? Below is a breakdown of average savings by industry: Identified Savings/Overcharges: Food Distribution Center $25,000 + per year Healthcare Facility $10,000 + per year Healthcare Facility $22,000 + per year Downtown office building $11,000 + per year Commercial Building $6,000 refund Apartment Building $15,000 + per year Grocery Store Chain $25,000 + per year Each company's needs are unique. That’s why Stryde's approach begins with a thorough evaluation of our Client's waste, providing us with the information needed to create a solution that’s right for them. Customized Programs – Once our expert staff has completed the analysis, we will create a customized program for each Client that will include increased recycling, tailored pick-up schedules, and correct-size equipment to determine if there is a more cost-effective way of handling the waste and recycling requirements. Contract Negotiations – We will contract the best haulers for Clients along with partners for e-waste, medical waste and recycling to ensure that they are receiving the best price from those vendors and we will handle the entire contract process for a Client from start to finish. Program Management – Stryde is contracted with each facility to manage all of the waste removal and recycling services with customized consolidated billing to meet a Client's individual accounting needs. Stryde will handle all of the customer service needs directly with the waste and recycling haulers and we continue to manage the cost saving activities. Clients manage the results. Invoice Auditing - Most property managers/owners lack the time and expertise required to effectively audit these accounts, nor do they realize overcharges exist. Our analysis includes finding loopholes by conducting a thorough review of the property, past invoices and pricing schedule. Whether the property is located in a city with set pricing or an open market, we know what it takes to uncover big savings. We have many other tax credits that can lower if not eliminate tax liability. Click on the link below and check it out. You may identify with these credits and want our services. https://lnkd.in/gXS-MZyn

Unlock new business opportunities with North Hires! 💼✨ Discover the art of proposal writing and strategic business development in our latest carousel. Let us help you craft compelling proposals that win clients and drive growth. Ready to elevate your business? Swipe through and connect with us today! 🚀 #BusinessDevelopment #ProposalWriting #NorthHires #GrowthStrategy #Consulting #NorthHiresConsulting #NHC #BusinessDevelopment #ProposalWriting

A virtual estimating process leverages technology for rapid response times and efficient quotes. Something that could have taken days now takes 24 hours. By embracing tech like photos, plans, and virtual meetings, your construction company can enhance scalability and lead acquisition. Ready for a smarter hiring process? Let's talk! . . . . #ConstructionRecruiting #Construction #Hiring #ConstructionJobs #ConstructionHiring #ConstructionRecruitment