Here in the query one more condition is added which is when the Rating is Hot.
select leadqualitycodename,* from filteredlead As fl inner join dbo.FilteredActivityParty as fap
ON fl.leadid=fap.partyid
and fl.leadid=‘yourleadid’ and leadqualitycodename=‘Hot’
Sharing my knowledge and experience about the Microsoft Power Platform.
a guide to powering up community
Technical Leadership Centred Around the Microsoft Data Platform
Deriving Solutions and features on Power Platform/Dynamics 365
Thoughts & musings from a Dynamics 365 Ninja!
Learn about Microsoft Dynamics CRM Power Platform customization and implementation and other cool stuffs
I know pre-stroke. I will improve who I was.
Balu Gajjala
Power Melange By Shalinee
Power Automate - Power Apps - SharePoint Online - Azure - Nintex - K2 - Artificial Intelligence
An Inquiry in Being
The Influencers & Influences of Indian Music
Hand's-free money management
A closer look at Microsoft Dynamics 365.
Experienced consultant primarily focused on Microsoft Dynamics 365 and the Power Platform
Specific topics by Django Lohn on the whole Microsoft365 Stack
One Stop Destination for Microsoft Technology Solutions
Naturally Curious
Prasanna Vadlamudi
Power Platform and Dynamics 365
A Microsoft Business Applications MVP
Bass defines your home theater
SQL Server tips and experiences dedicated to my twin daughters.
Discovering Azure DevOps and D365 Business Applications
Lets do IT Spells
český jiřetín
Russ Parry REALTOR®
Power Platform & Dynamics CRM
Mail to crmtipsbyprm@gmail.com for queries and suggestions
Giving back to the community what I have learned
Learn and Share
Dynamics CRM Technical & Functional Info
Sometimes you need to look at things from different perspective.
Dynamics 365 Customer Engagement, CRM, Microsoft CRM, Dynamics CRM
Step into the world of a Dynamics 365 Consultant
Diana & Dynamics 365 & Power Platform
No Code Customization Concepts
Nishant Rana's Weblog 